We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, 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."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"It's very easy to use it to develop mappings and workflows."
"It reduces a lot of legacy coding."
"It's a complete package, which is why we use this solution."
"UI-based ability to create data mapping."
"It is UI friendly and has all the advantages of an ETL tool."
"I like the completeness of the way I can build ETL workflows."
"It's something I needed for bulk imports. I'm not a big fan of it, but I haven't seen anything better."
"The data reader is the most valuable feature."
"SSIS is an easy way to do data integration from various data sources. It doesn't matter whether it's a database, flat files, XML, or Web API. It can talk to the and join them all together."
"Overall, it's a good product."
"The debugging capabilities are great, particularly during data flow execution. You can look into the data and see what's going on in the pipeline."
"It is easily scheduled and integrates well with SQL Server and SQL Server Agent jobs."
"It's already very user-friendly and has a good dashboard."
"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."
"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)."
"Requires an established data center because there is no option for software as a service."
"The performance of Informatica PowerCenter could improve."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Include more instruments for LOGs analysis, interpretation, and job corrections."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"The licensing is difficult."
"There is some room for improvement in terms of pricing."
"We'd like them to develop data exploration more."
"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."
"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."
"Improving the login procedure would make our reporting easier on monitoring our ETL processes."
"A change in the metadata source cripples the whole ETL process, requiring each module to be manually reopened."
"In terms of its performance, it could be better. That could be something that would be easy and welcomed as an upgrade."
"We've had issues in terms of the amount of data that is transferred when we are scheduling."
"Improvement as per customer requirements."
Earn 20 points