We performed a comparison between Actian Pervasive Data Integrator [EOL] and Informatica PowerCenter 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."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"PowerCenter performs well during data transformation and optimization."
"The ability to scale through partitions helped us to improve the performance."
"It is an excellent ETL tool."
"I like the automated scheduling feature."
"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)."
"It should be more cloud-centric than on-prem-centric."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"The licensing is difficult."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
Earn 20 points
Actian Pervasive Data Integrator [EOL] doesn't meet the minimum requirements to be ranked in Data Integration while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Actian Pervasive Data Integrator [EOL] is rated 5.8, while Informatica PowerCenter is rated 8.0. The top reviewer of Actian Pervasive Data Integrator [EOL] writes "You can use it to send data back and forth between Salesforce.com and JD Edwards". On the other hand, the top reviewer of Informatica PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". Actian Pervasive Data Integrator [EOL] is most compared with , whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue.
See our list of best Data Integration vendors.
We monitor all Data Integration 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.