We performed a comparison between Collibra Catalog and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management."We have had no complaints about the stability."
"Collibra Catalog is simple to use and user-friendly for those who are not technically inclined since it is easy to find while also easy to see data lineage diagrams."
"Collibra Catalog's best feature is the data quality checker."
"The data lineage capability is valuable as it shows how different sources are connected and how data flows, which is crucial for projects like migrations. Moreover, data lineage visualization in Collibra Catalog aids our data governance initiatives."
"Collibra Catalog has significantly enhanced data governance and compliance for our team, primarily through its valuable feature of endpoint lineage enabling visual representation of the data."
"The solution is easy to use and developer friendly."
"The initial setup was easy."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"The ability of SSIS to transform and transport data is extremely valuable to me. It allows for intelligent extraction and manipulation of data during the process. Improved error handling would enhance ETL processes further. I haven't directly utilized the data flow components but they seem capable of supporting complex data integration needs."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It has good data integration and good processes."
"Built in reports show package execution and messages. Logging can also be customized so only what is needed is logged. There is also an excellent logging replacement called BiXpress that provides both historical and real-time monitoring which is more efficient and much more robust than the built-in logging capabilities. And none of this requires custom coding to make it useful unlike many other ETL tools."
"The most important features are it works well and provides self-service BI."
"A key area for improvement in Collibra Catalog lies in its integration capabilities, particularly with a broader range of sources."
"I'd like to see more integration with other reporting sources."
"The tool's overall functionalities need to improve since, nowadays, many tools, from a business perspective, are easy to use."
"Collibra Catalog could improve its automation to increase the efficiency of the software."
"At one point, we did have to purchase an add-on."
"It hangs a lot of the time."
"You have to write push down join & lookup SQL to the database yourself via stored procedures or use of the SQL Task to get very high performance. That said, this is a common complaint for nearly all ETL tools on the market and those that offer an alternative such as Informatica offer them at a very expensive add-on price."
"Performance could be better."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"I would like to see better integration with Power BI."
"SSIS doesn't have a very good user interface, but if you can work with it, it'll provide you with almost all of the functionality."
"The performance of this solution is not as good as other tools in the market."
Collibra Catalog is ranked 5th in Metadata Management with 5 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Collibra Catalog is rated 7.8, while SSIS is rated 7.6. The top reviewer of Collibra Catalog writes "A user-friendly for those who are not technically inclined and useful for cataloging various reports". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Collibra Catalog is most compared with Informatica Enterprise Data Catalog, Ab Initio Co>Operating System, Talend Data Management Platform, Palantir Foundry and Denodo, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) and AWS Glue.
We monitor all Metadata Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.