Alation offers enterprise data intelligence solutions, including data search & discovery, data governance, data stewardship, analytics, and digital transformation. Alation operates in thethe data catalog market. With its Behavioral Analysis Engine, inbuilt collaboration capabilities, and open interfaces, Alation combines machine learning with human insight with the goal of tackle the most demanding challenges in data and metadata management.
N/A
DBeaver
Score 8.5 out of 10
N/A
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
$11
per month per user
DataGrip
Score 9.5 out of 10
N/A
DataGrip, from JetBrains, is a database IDE that is tailored to suit the specific needs of professional SQL developers.
Alation is well suited to helping a user find a column or even a query using a business term search. In this regard Alation is excellent because it's easy to not only associate these items with each other, but there are also many ways to link the column and/or query to that business term/concept
If you are connecting to Snowflake and want to query from your laptop, I find that this is much easier to use than Snowflake's IDE. It allows us as a business intelligence team to more easily connect to our servers, and code with much less hassle. It would be less appropriate if you are only on an on-premises SQL server, in that case, I would just use SSMS.
You will like DataGrip; it is the best software to channel and influence data systems and efficiently. It will help you be more efficient and productive in exporting computer data; it is very effective. There are no errors, and you will feel comfortable using them. It promotes data quality and has excellent graphics to represent your information through statistical processes.
Ability to link objects using the @ symbol. It allows us to easily provide a way to get more information or context. So if the business concept is part of a hierarchy, we can link to the other terms in that hierarchy.
The customization is really helpful. Most object types have robust customization options. Others are less so, but it is improving. We've created multiple custom fields to support our data governance framework.
The search feature with filtering is helpful in narrowing down what you're looking for.
The lineage UI is not ready for primetime. I would not recommend this feature for my users at this time because it's too complex to understand and is visually difficult to track down specific paths.
The underlying infrastructure of the on-premise version of the software is fragile and unnecessarily complicated, using too many modules and technologies.
The license model of the on-premise version contains too many add-ons. I would like to pay one price and get all of the features.
Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
Sorting and filtering in data is nice, but buried in long right-click menus.
Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.
Overall, we are happy with the functionality of the platform. While there are are areas that we would like to see further improvement in, the tooling is highly configurable and aligns well with our use case. A mature API layer makes it straightforward to integrate with other data tooling. Alation stands out for its pro-active engagement with their customers, both to resolve issues and in communicating their feature roadmap
Alation Data Catalog is generally easy to use for finding datasets, reviewing documentation, and understanding ownership. The platform makes data discovery more efficient and improves trust in shared assets. I rated it 7 because the navigation can be complex at times, and the search results could be more precise and easier to refine.
Usability has two aspects, being a complete tool and being easy... DataGrip has a lot of features but it is big, not clear how to use most of the things and most people won't need them. In my opinion, usability is good enough but not friendly.
The account management and technical support teams are both excellent. There is regular account manager engagement, and technical issues are generally resolved very quickly. The vendor engages us in product development through regular updates on the product strategy & feature roadmap.
Not a lot of users have DBeaver so fewer resources are available online to help you if you have any issues. When I was trying to figure out how to create my own ER diagrams, it was a little tough to find resources
Key insight from implementing Alation is that, as a cloud-based SaaS product, the majority of effort is not infrastructure-related but instead focused on security configuration and integration with existing platforms, including identity management, access controls, and metadata connectivity to core data systems. Because of its data profiling functionality, careful consideration had to be given to data security and data sovereignty.
Alation provided the right balance of connection with systems in use, trusted reputation and affordability. The product integrates with current ways of working and does not require reorganisation within other lines of business.
MySQL workbench from MySQL only supports MySQL databases and it only provides basic functionality. On top of that, the user experience could be quite confusing for first-time users. SSMS from SQL server doesn't support inline editing nicely. The view for inline editing and view data is different, making it uncomfortable to use. All in all, DBeaver is the best tool when you manage a lot of databases with different types.
DataGrip provides a single UI for many DBMS platforms, instead of using one for each. Because of that, you can migrate things between platforms using the tool and "look across" all databases at once.
We've had limited but very positive impact for 3 data subject matter experts. In the past they were fielding very similar questions from users stumbling on their data. Now, rather than responding to each email or chat message, they not only direct users to the catalog but they also reach out to me to do a walk-through of Alation's other features.
Another positive impact is having the data dictionary live in one location. This has been tremendous in making the dictionaries accessible and consistent.
