We performed a comparison between Informatica Enterprise Data Catalog and SSIS based on real PeerSpot user reviews.
Find out in this report how the two Metadata Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Multifeatured and easily scalable data catalog, with good data domain discovery and data profiling features."
"The solution scales well."
"I rate the technical support a ten out of ten."
"We can scan anything."
"The most valuable feature of Informatica Enterprise Data Catalog is it provides clients with a full view of the enterprise data assets. For example, how many data assets they have and who owns them."
"The capability of the tool to scan and capture the metadata from a variety of sources is one of the capabilities that I find most useful. The central repository into which it is going to put that captured metadata is the best."
"The product seems stable enough."
"I like EDC's self-service capabilities. You can put the catalog on the intranet inside the organization, so users can search for something. People in the research world have specialized systems, and you might find data from various places that sound similar."
"The most important features are it works well and provides self-service BI."
"This solution is easy to implement, has a wide variety of connectors, has support for Visual Basic, and supports the C language."
"It has good data integration and good processes."
"The script component is very powerful, things that you cannot normally do, is feasible through C#."
"We like that this solution includes a developer edition, free of charge, to allow for training."
"The initial setup of this solution is very straightforward."
"SSIS is easy to use."
"The simplicity of the solution is great. The solution also offers excellent integration."
"Interoperability is one area where EDC has room for improvement. It was challenging when the faculty took over the data world and had specific vendors they wanted to use, and some were not particularly open platforms."
"It is not easy to set up and configure the tool."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen."
"The scalability is tough."
"The model is somewhat flexible. There are certain aspects of the model that are not as flexible as we would like. It doesn't do certain things to a great level of depth. So, in situations where we want to drill in to do something specific, we have to essentially copy that data into our own structures in order to add that additional layer of flexibility."
"IEDC can improve the comparison of lineages."
"They have to improve their relationship discovery tool. They say that they have AI inside, but this AI did not automatically find relationships or suggested relationships between entities."
"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."
"There is connectivity with other databases, however, this is the most significant issue that has to be addressed."
"SSIS can improve in handling different data sources like Salesforce connectivity, Oracle Cloud's connectivity, etc."
"It would be nice if you could run SSIS on other environments besides Windows."
"SSIS is stable, but extensive ETL data processing can have some performance issues."
"There were some issues when we tried to connect it to data storage. It was a connection issue."
"We'd like them to develop data exploration more."
"We would like the solution to be expanded so that it is available for other platforms than just Microsoft."
More Informatica Enterprise Data Catalog Pricing and Cost Advice →
Informatica Enterprise Data Catalog is ranked 1st in Metadata Management with 12 reviews while SSIS is ranked 2nd in Data Integration with 68 reviews. Informatica Enterprise Data Catalog is rated 7.4, while SSIS is rated 7.8. The top reviewer of Informatica Enterprise Data Catalog writes "Great metadata management with more visibility and great technical support". On the other hand, the top reviewer of SSIS writes "Maintaining the solution and contacting its support team is easy". Informatica Enterprise Data Catalog is most compared with Alation Data Catalog, Collibra Catalog, AWS Glue, Informatica PowerCenter and Denodo, whereas SSIS is most compared with Informatica PowerCenter, Talend Open Studio, Oracle Data Integrator (ODI), IBM InfoSphere DataStage and AWS Glue. See our Informatica Enterprise Data Catalog vs. SSIS report.
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.