We performed a comparison between erwin Data Catalog by Quest and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Informatica, Alation, SAP and others in Metadata Management."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."
"It has a drag and drop feature that makes it easy to use. It has a good user experience because it takes into account your most-used tools and they're lined up nicely so you can just drag and drop without looking too far. It also integrates nicely with Microsoft."
"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."
"The solution is stable."
"The most valuable thing is that it is easy to connect with Microsoft tools. In Europe, particularly in France, a lot of companies use Excel, SQL Server, and other Microsoft tools, and it is easier to connect SSIS with Microsoft tools than other products."
"The most valuable feature of SSIS is its ease of use. It is easier to use than other applications."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"There are many good features in this solution including the data fields, database integration, support for SQL views, and the lookups for matching information."
"Data Flows are the main component we use. These can range from a simple source to sink ETL, to many source to many sink dataflows."
"There is room for improvement with respect to the connector and how to connect to the structured and unstructured database."
"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 are a lot of things that Microsoft could improve in relation to SSIS. One major problem we faced was when attempting to move some Excel files to our SQL Server. The Excel provider has a limitation that prevents importing more than 255 columns from a particular Excel file to the database. This restriction posed a significant issue for us."
"The interface could use improvement, as well as the administrative tools. Jobs fail from time to time for different reasons. It's not a problem with Microsoft, or SSIS itself. The problems are external, but to find the problems and analyze them it takes too much time."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
"Generic processes should be used instead of custom code for each table."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"We have a stability problem because when something works, it works one time. The next time, it doesn't work."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
erwin Data Catalog by Quest is ranked 12th in Metadata Management with 2 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. erwin Data Catalog by Quest is rated 7.6, while SSIS is rated 7.6. The top reviewer of erwin Data Catalog by Quest writes "Helps with metadata management, saves time, and allows us to do impact analysis on any changes". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". erwin Data Catalog by Quest is most compared with Informatica Enterprise Data Catalog, Talend Open Studio, Oracle Data Integrator (ODI), Alation Data Catalog and Azure Data Factory, 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.