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 product seems stable enough."
"The most valuable feature is its ability to extract metadata from various sources- be it an old SaaS application or the latest cloud application."
"We can scan anything."
"It can automatically connect or associate business terms with various options, providing flexibility beyond general capabilities."
"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 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."
"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 solution scales well."
"The data reader is the most valuable feature."
"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 reporting on the solution is perfect. I didn't expect to see reporting features, but they are great."
"The scalability of SSIS is good."
"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 important features are it works well and provides self-service BI."
"The most valuable features for our company are the flexibility and the quick turn around time in producing simple ETL solutions."
"The setup was easy. All Microsoft products are easy to set up."
"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)."
"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 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."
"The solution is quite expensive."
"Currently, there are limitations in processing and the interface."
"The UX and UI of the solution are areas with certain shortcomings where improvements can be made in the future."
"Informatica Enterprise Data Catalog could improve by having a much better user interface. It is not user-friendly."
"IEDC can improve the comparison of lineages."
"The scalability is tough."
"Microsoft's technical support has decreased in quality over the last few years, becoming less responsive and tending to pass problems on instead of solving them."
"It should have other programming languages supported as well from a scripting perspective. Currently, only C# and VB.NET are supported, which limits it to .NET. It should have Java support as well."
"It would be nice if you could run SSIS on other environments besides Windows."
"I would like to see better integration with Power BI."
"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."
"It needs more integration tools, so you can connect to different sources."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"The debugging could be improved because when it came to solving the errors that I've experienced in the past, I've had to look at the documentation for more information."
More Informatica Enterprise Data Catalog Pricing and Cost Advice →
Earn 20 points