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

SSIS vs erwin Data Catalog by Quest comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

erwin Data Catalog by Quest
Average Rating
7.6
Number of Reviews
2
Ranking in other categories
Metadata Management (11th)
SSIS
Average Rating
7.8
Number of Reviews
71
Ranking in other categories
Data Integration (4th)
 

Mindshare comparison

erwin Data Catalog by Quest and SSIS aren’t in the same category and serve different purposes. erwin Data Catalog by Quest is designed for Metadata Management and holds a mindshare of 2.9%, up 2.5% 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

Andres-Martinez - PeerSpot reviewer
Mar 21, 2022
Helps with metadata management, saves time, and allows us to do impact analysis on any changes
There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names. There were some issues when drawing the data models. If you have more than 500 or 600 tables, it takes a long time to display those in the right position on the screen. That can also be improved. They need some caching and some parallel pipelines working on the backend in order to divide it into sections.
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

"When you combine it with data lineage, every time you need to make a change, it allows you to do impact analysis on any changes and then connect to the end-users or data stewards so that they can be aware that a change is coming. That's one of the main benefits we use it for."
"The data catalog feature is pretty good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"SSIS provides you with lookup and transformation functions, and you have the flexibility to write your own custom code."
"In SSIS, the scope is not only to handle ETL challenges, but it will allow us to do so many other tasks, such as DBA activities, scripting, calling any .exe or scripts, etc."
"Its compatibility with Microsoft products has been very valuable to our company. It fits well within the architecture."
"The initial setup of this solution is very straightforward."
"It is easy to set up. The deployment is also very quick."
"The most valuable feature of the solution is performance."
"It is also easy to learn and user-friendly. Microsoft is also good in terms of technical support. They have built a large community all over the world."
 

Cons

"There are always ways to improve things. For example, we can use AI to be able to find out something. When we are typing something, if we don't know the exact term, Artificial Intelligence would be useful to find terms that are phonetically or syntactically similar. Instead of having to type in the exact name, they can provide those in the list. So, they can provide AI support for the search because when you have thousands and thousands of terms, it is hard to remember all the names."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"The high prices attached to the product can be an area of concern where improvements are required."
"The solution could improve by having quicker release updates."
"I would like to see better technical documentation because many times information is missing."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"It hangs a lot of the time."
"Performance could be better."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"Improvement as per customer requirements."
 

Pricing and Cost Advice

"Erwin Data Catalog is very expensive."
"I am not very familiar with its pricing. I know it is not cheap, but it is also not super expensive. It depends on the company size. For a company making $1 million, it is very expensive. For a company making 10 million and above, it might be okay."
"Depending on the arrangement that a certain company has with Microsoft, it may supply the permanent license that is included in the SQL server license, or it may be a time-bound license if it is a partner license or other enterprise license."
"This solution has provided an inexpensive tool, and it is easy to find experienced developers."
"This solution is included with the MSSQL server package."
"It would be beneficial if the solution had a less costly cloud offering."
"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."
"People have to opt for a perpetual-based licensing model."
"The solution is available at a lesser price than that of Informatica."
"All of my clients have this product included as part of their Microsoft license."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
815,854 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
20%
Government
12%
Computer Software Company
10%
Manufacturing Company
10%
Financial Services Firm
17%
Computer Software Company
12%
Government
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

Which ETL tool would you recommend to populate data from OLTP to OLAP?
There are two products I know about * TimeXtender : Microsoft based, Transformation logic is quiet good and can easily be extended with T-SQL , Has a semantic layer that generates metat data for cu...
What is your experience regarding pricing and costs for erwin Data Catalog?
Erwin Data Catalog is very expensive. I would rate it a two out of five for affordability.
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

Balfour Beatty Construction, Banco de México, BFSI Canada, CenturyLink, Daktronics
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: November 2024.
815,854 professionals have used our research since 2012.