Try our new research platform with insights from 80,000+ expert users

Collibra Catalog vs SSIS comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Collibra Catalog
Average Rating
7.8
Number of Reviews
5
Ranking in other categories
Metadata Management (4th)
SSIS
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

Collibra Catalog and SSIS aren’t in the same category and serve different purposes. Collibra Catalog is designed for Metadata Management and holds a mindshare of 11.2%, up 8.6% compared to last year.
SSIS, on the other hand, focuses on Data Integration, holds 8.6% mindshare, down 9.6% since last year.
Metadata Management
Data Integration
 

Featured Reviews

Aditya Pawar - PeerSpot reviewer
Mar 1, 2024
Effective for data discovery and supports multiple authentication methods, not just username and password
For data discovery, we create datasets. The most frequently used datasets are featured on the dashboard. Users can create their own if their requirements aren't met by the most frequently used datasets. We also create data requests, and owners can approve these requests, which adds a process layer to accessing particular datasets. So, it has been effective for data discovery in our company. I use different functionalities within the tool. I use Collibra Catalog for metadata management or Collibra Lineage for data governance. Once configured, data in the Catalog will be automatically updated, reducing the need for manual maintenance. So, the automation feature has positively impacted our data management tasks.
Sakiru Dosumu - PeerSpot reviewer
Mar 1, 2024
Its ability to transform and transport data is extremely valuable
We use SSIS for data extraction, transformation, and loading processes. This includes extracting data from various sources like Oracle and SQL Server, and then transforming it for use in reporting tools like Power BI dashboards. While we haven't directly migrated data between databases using SSIS…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"We have had no complaints about the stability."
"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 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 has significantly enhanced data governance and compliance for our team, primarily through its valuable feature of endpoint lineage enabling visual representation of the data."
"Collibra Catalog's best feature is the data quality checker."
"I have used most of the standard SQL features, but the ones that stand out are the Data Flows and Bulk Import."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The most valuable aspect of this solution is that it is simple to use and it offers a flexible custom script task."
"Like most Microsoft products, SSIS is user-friendly and easy to use."
"You can get data from any data source with SSIS and dump it to any outside source. It is helpful. Getting, extracting, converting, and dumping data doesn't require much effort because we can do everything in the user interface. You drag and drop, then give the required input. It's intuitive."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuables features are the relatively short learning curve, and the automation capabilities provided through the BIML add-in for SSDT."
"The most important features are it works well and provides self-service BI."
 

Cons

"A key area for improvement in Collibra Catalog lies in its integration capabilities, particularly with a broader range of sources."
"Collibra Catalog could improve its automation to increase the efficiency of the software."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"At one point, we did have to purchase an add-on."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"It needs more integration tools, so you can connect to different sources."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
 

Pricing and Cost Advice

"I think they can bring a few more features and align better with other quality products."
"Collibra offers a per-user licensing model."
"Collibra Catalog is fairly priced - I would rate their pricing seven out of ten."
"The product is highly priced compared to other vendors."
"It comes bundled with other solutions, which makes it difficult to get the price on the specific product."
"If you don't want to pay a lot of money, you can go for SSIS, as its open-source version is available. When it comes to licensing, SSIS can be expensive."
"My advice is to look at what your configuration will be because most companies have their own deals with Microsoft."
"This solution is a free of charge addition to our SQL licence. However, the only way this tool can be utilized is as a feature of the SQL licence, which may make it unattractive to organizations who don't wish to purchase the wider-ranging licence."
"All of my clients have this product included as part of their Microsoft license."
"Based on my experience and understanding, Talend comes out to be a little bit expensive as compared to SSIS. The average cost of having Talend with Talend Management Console is around 72K per region, which is much higher than SSIS. SSIS works very well with Microsoft technologies, and if you have Microsoft technologies, it is not really expensive to have SSIS. If you have SQL Server, SSIS is free."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"Our license with SSIS is annual."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
29%
Computer Software Company
15%
Energy/Utilities Company
6%
Manufacturing Company
6%
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Manufacturing Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about Collibra Catalog?
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 C...
What needs improvement with Collibra Catalog?
I'd like to see more integration with other reporting sources like Qlik Sense, beyond the currently supported ones like Tableau and Power BI.
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
What do you like most about SSIS?
The product's deployment phase is easy.
 

Also Known As

No data available
SQL Server Integration Services
 

Overview

 

Sample Customers

AXA XL, DNB, Adobe, PMI, Holland America Line, UC Davis Health, Cox Automotive
1. Amazon.com 2. Bank of America 3. Capital One 4. Coca-Cola 5. Dell 6. E*TRADE 7. FedEx 8. Ford Motor Company 9. Google 10. Home Depot 11. IBM 12. Intel 13. JPMorgan Chase 14. Kraft Foods 15. Lockheed Martin 16. McDonald's 17. Microsoft 18. Morgan Stanley 19. Nike 20. Oracle 21. PepsiCo 22. Procter & Gamble 23. Prudential Financial 24. RBC Capital Markets 25. SAP 26. Siemens 27. Sony 28. Toyota 29. UnitedHealth Group 30. Visa 31. Walmart 32. Wells Fargo
Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management. Updated: October 2024.
814,649 professionals have used our research since 2012.