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."
"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."
"The workflow features have been very valuable. You can have automated workflows and all the steps are controlled. The workflow functionality of integration services is excellent."
"The setup is straightforward. It's very easy to install."
"The scalability of SSIS is good."
"It has good data integration and good processes."
"The solution is stable."
"The most valuable features of SSIS are that it works with the query language and it can import data from different sources."
"The solution is easy to use and developer friendly."
"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 creation of the measure in the DAC's model could be improved."
"SSIS is cumbersome despite its drag-and-drop functionality. For example, let's say I have 50 tables with 30 columns. You need to set a data type for each column and table. That's around 1,500 objects. It gets unwieldy adding validation for every column. Previously, SSIS automatically detected the data type, but I think they removed this feature. It would automatically detect if it's an integer, primary key, or foreign key column. You had fewer problems building the model."
"Video training would be a helpful addition."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The solution should work on the GPU, graphical processing unit. There should also be piping integration available."
"The high prices attached to the product can be an area of concern where improvements are required."
"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."
"The solution could improve on integrating with other types of data sources."
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.