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, Collibra and others in Metadata Management."The data catalog feature is pretty good."
"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."
"It has the ability to be deployed into the cloud through Data Factory, and run completely as a software as a service in the cloud."
"The most valuable feature of SSIS is that it can handle real complex transformations."
"The most valuable feature of SSIS is that you can take data from other servers which are not MS SQL Server or Oracle."
"It has good data integration and good processes."
"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 solution is easy to use and developer friendly."
"We can connect with multiple data sources easily using an external connector in SSIS."
"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."
"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."
"I have a tool called ZappySys. I need that tool to cut down on the complexity of SSIS. That tool really helps with a quick turnaround. I can do things quickly, and I can do things accurately. I can get better reporting on errors."
"We have issues with SSIS connectors while extracting data from Excel sources."
"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."
"I would also like to see full integration with our BI because then our full load of data will be available in our organization. They should incorporate an ATL process."
"Improvement as per customer requirements."
"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."
"We purchase an add on called task factory primarily to allow bulk delete, update and upsert capability. I'd like to see this be part of the standard package."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
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, Alation Data Catalog, Oracle Data Integrator (ODI) 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.