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."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 valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application."
"The way that the solution scans is very useful."
"The metadata management of Informatica is great."
"The solution scales well."
"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."
"We can scan anything."
"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."
"It's a competent product."
"It is easy to set up the product."
"SSIS integrates well with SQL servers and Microsoft products."
"The scalability of SSIS is good."
"The performance is better than doing it in some alternative ways. We don't have to worry about so much manual work."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"The initial setup was easy."
"Currently, there are limitations in processing and the interface."
"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."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"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."
"It is more complicated to extract data using the product compared to Visio. The system could display the details on the screen."
"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."
"Informatica Enterprise Data Catalog could improve by having a much better user interface. It is not user-friendly."
"It is not easy to set up and configure the tool."
"Sometimes, there are compatibility issues with some features. From time to time, I also face issues when trying to migrate. If I misconfigure things when I use Snapshot, the migration will fail.It can take a long time to migrate huge amounts of data, so it would be nice if that could be faster."
"Performance could be better."
"This solution needs full support for real-time processing."
"We have issues with SSIS connectors while extracting data from Excel sources."
"The solution could improve by having quicker release updates."
"When I compare Talend and SSIS, Talend provides more features. With Talend, we can handle a large volume of data. Talend is usually used to treat a large volume of data, which makes it better than SSIS on the data side. Talend also has a very good Talend Management Console to schedule the jobs and do other things. It can also be easily connected to version control tools such as GitHub or SVN. The last time I used SSIS, it was connected through TSS for the Windows Console version. I am not sure it has been improved or not. If it is not improved, Microsoft should improve it. They should change the product to provide another console."
"Sometimes we need to connect to AWS to get additional data sources, so we have to install some external LAN and not a regular RDBMS. We need external tools to connect. It would be great if SSIS included these tools. I'd also like some additional features for row indexing and data conversion."
"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."
More Informatica Enterprise Data Catalog Pricing and Cost Advice →
Informatica Enterprise Data Catalog is ranked 1st in Metadata Management with 13 reviews while SSIS is ranked 2nd in Data Integration with 69 reviews. Informatica Enterprise Data Catalog is rated 7.6, while SSIS is rated 7.6. 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, IBM InfoSphere DataStage, Oracle Data Integrator (ODI) 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.