We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros | |
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files." "Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better." "The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage." "In the end, you have structured, proper data for use in an integrated BI solution." "The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand." "Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical." "The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution." "The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed." | "This solution has a well-known procedure for troubleshooting and tuning the performance, providing for smooth operation." "This solution provides us with real-time replication and it does not affect the performance of other operations, which is very important to us." "When we are replicating data between similar databases then it is straightforward." "The initial setup is straightforward. It doesn't take too much time or effort to implement the solution." "This is a powerful solution provided by one of the most respected companies in the computer industry." "The most valuable feature is data replication capability." "The CDC feature is interesting." "They've recently improved the ease of implementation." |
Cons | |
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease." "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." "Integration with Artificial Intelligence would benefit this solution." "I would like to see an improvement in the digital adoption." "The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica." "Include more instruments for LOGs analysis, interpretation, and job corrections." "I found it is kind of weird that not all of the mapping changes are treated as true changes." | "Additional performance metrics should be added and visible in a dashboard, displayed in a detailed manner." "I find the user interface to be difficult for non-technical people." "The process of transforming the data between two different databases is inefficient and needs to be improved." "The solution, in general, should be easier to use, with less need to perform workarounds within the system." "Technical support for Oracle products needs to be more efficient (at least locally in Egypt)." "It should be easier to integrate this solution with non-Oracle databases, including cloud-based solutions hosted on Azure." "We struggle with memory. It's limited. However, it may be because of our unique business case and how we use it that it's limiting for us." "The solution is quite costly, and if they could reduce their pricing, it would be more economical to implement." |
Pricing and Cost Advice | |
"Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis." "Its maintenance is expensive." "It's much more expensive, almost three times more expensive than most other solutions." "We are satisfied with the pricing." "I consider this to be an expensive product." | "The licensing model should be improved to be more cost-effective for the end users." "We do like the price of this solution." "Pricing is based on anual licensing with additional costs for support packages." "The price of this solution is good." |
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs. 455,301 professionals have used our research since 2012. | |
Questions from the Community | |
Top Answer: Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System. Top Answer: Its maintenance is expensive. Top Answer: Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was… more » | Top Answer: Depends upon the technologies being used. If you're using Oracle for both OLTP and OLAP then you'll get a lot of value from an Oracle solution.
The other question is how up to date do you want your… more » Top Answer: The most valuable feature is data replication capability. Top Answer: The price of this solution is good. |
Ranking | |
Views 40,460 Comparisons 32,402 Reviews 14 Average Words per Review 367 Rating 8.2 | Views 19,486 Comparisons 11,389 Reviews 8 Average Words per Review 578 Rating 8.3 |
Popular Comparisons | |
![]() Compared 16% of the time. ![]() Compared 14% of the time. ![]() Compared 9% of the time. ![]() Compared 8% of the time. ![]() Compared 2% of the time. | ![]() Compared 14% of the time. ![]() Compared 14% of the time. ![]() Compared 11% of the time. ![]() Compared 10% of the time. ![]() Compared 5% of the time. |
Also Known As | |
PowerCenter | GoldenGate |
Learn | |
Informatica | Oracle |
Overview | |
Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems. | Oracle GoldenGate is a comprehensive software package for real-time data integration and replication in heterogeneous IT environments. The product set enables high availability solutions, real-time data integration, transactional change data capture, data replication, transformations, and verification between operational and analytical enterprise systems. |
Offer | |
Learn more about Informatica PowerCenter | Learn more about Oracle GoldenGate |
Sample Customers | |
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank | Japan Exchange Group, Daewoo E&C, Herbalife, Starwood Hotels & Resorts, Canon, Turk Telekom |
Top Industries | |
Financial Services Firm18% Retailer14% Healthcare Company9% Computer Software Company9% Computer Software Company38% Comms Service Provider13% Insurance Company6% Financial Services Firm6% | Healthcare Company20% Retailer10% Music Company10% Financial Services Firm10% Computer Software Company41% Comms Service Provider14% Media Company8% Financial Services Firm5% |
Company Size | |
Small Business14% Midsize Enterprise10% Large Enterprise76% Small Business2% Midsize Enterprise12% Large Enterprise86% | Small Business43% Midsize Enterprise17% Large Enterprise39% |
Informatica PowerCenter is ranked 1st in Data Integration Tools with 16 reviews while Oracle GoldenGate is ranked 7th in Data Integration Tools with 9 reviews. Informatica PowerCenter is rated 8.2, while Oracle GoldenGate is rated 8.2. The top reviewer of Informatica PowerCenter writes "Assists us with integration as we migrate from on-premise to cloud, but it needs a performance analyzer". On the other hand, the top reviewer of Oracle GoldenGate writes "Powerful solution that centralizes our data and has a user-friendly interface ". Informatica PowerCenter is most compared with SSIS, Informatica Cloud Data Integration, Azure Data Factory, Oracle Data Integrator (ODI) and Informatica Data Integration Hub, whereas Oracle GoldenGate is most compared with Oracle Data Integrator (ODI), AWS Database Migration Service, Qlik Replicate, Quest SharePlex and SSIS. See our Informatica PowerCenter vs. Oracle GoldenGate report.
See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.
We monitor all Data Integration Tools 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.