We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica Enterprise Data Catalog, and SSIS based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"The way that the solution scans is very useful."
"I rate the technical support a ten out of ten."
"We can scan anything."
"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 most valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application."
"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 product seems stable enough."
"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."
"With this solution, there is the potential to expand, so that you can immediately write code onto the SQL server."
"The most valuable features of this solution are the fast insert and fuzzy logic matching."
"SSIS' best feature is SFTP connectivity."
"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."
"It has good data integration and good processes."
"The reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"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."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"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."
"This solution is hard to set up and its interface is not user-friendly. It's also not as stable, and the technical support takes a lot of time to solve simple problems."
"The scalability is tough."
"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 solution is quite expensive."
"Currently, there are limitations in processing and the interface."
"IEDC can improve the comparison of lineages."
"The performance of SSIS could improve when comparing it to Oracle Database."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"We In upgrading SSIS, we encountered challenges fixing SQL Server and performance issues, including problems during a failover in our data warehouse."
"Options for scaling 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."
"We're in the process of switching to Informatica, and we need to work out data lineage and data profiling and to improve the quality of our data. SSIS, however, is not that compatible with Informatica. We managed to connect it to Informatica Metadata Manager, but we don't get good lineage, so we have to redo all our ETLs using the Informatica process in order to accept the proper data lineage."
"SSIS sometimes hangs, and there are some problems with servers going down after they've been patched."
"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 →
Earn 20 points
