Try our new research platform with insights from 80,000+ expert users

Actian Ingres vs Informatica PowerCenter comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Actian Ingres
Average Rating
8.6
Reviews Sentiment
7.9
Number of Reviews
2
Ranking in other categories
Relational Databases Tools (26th), Data Warehouse (17th)
Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
82
Ranking in other categories
Data Integration (3rd), Data Visualization (9th)
 

Featured Reviews

GH
Reliable performance enhances operations with good technical support
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks and the IRS The most valuable features for us are reliability and performance. Our system is used…
Deepak Shiv - PeerSpot reviewer
Provides multiple transformations in one toolset and helpful when extracting data from multiple sources
Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix. AI Initiatives: Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"The most valuable features for us are reliability and performance."
"The number of docs has been reduced drastically, which is very good."
"Once you have learned Informatica, it is very easy to use."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"In the end, you have structured, proper data for use in an integrated BI solution."
"Informatica PowerCenter is a very good ETL tool."
"It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
 

Cons

"The seamless integration is a bit of an issue."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"The UI is a little outdated."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff. Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
 

Pricing and Cost Advice

Information not available
"I am not sure about the most recent price, but I think it should be $100,000 or more."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"Cost could be improved."
"Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho. There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users."
"We have a site license, but we do pay by the division."
"Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it."
"Its maintenance is expensive."
report
Use our free recommendation engine to learn which Data Visualization solutions are best for your needs.
865,384 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Computer Software Company
22%
Insurance Company
8%
University
8%
Government
8%
Financial Services Firm
18%
Computer Software Company
11%
Manufacturing Company
8%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with Actian Ingres?
The seamless integration is a bit of an issue. I would like to see more direct connectors and stuff like SQLAlchemy. It's there but isn't available as a standard, so it involves going to GitHub to ...
What is your primary use case for Actian Ingres?
We run the entire IRS system, the income system, and the tax system. We also manage the entire Absa banking system in Africa. There's a lot of database applications, similar to those used in banks ...
What is your experience regarding pricing and costs for Actian Ingres?
Initially, it's a lot less expensive than competitors. Price performance has always been a priority, ensuring we remain competitive in the market.
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
 

Also Known As

Ingres, Ingres 2006
PowerCenter
 

Overview

 

Sample Customers

Groupe Adeo, IsCool Entertainment
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Actian Ingres vs. Informatica PowerCenter and other solutions. Updated: July 2025.
865,384 professionals have used our research since 2012.