We performed a comparison between Informatica PowerCenter and Oracle Data Integrator Cloud Service based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly."
"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."
"The solution is stable."
"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."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"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."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"The most valuable thing to me is its simplicity. A person with zero knowledge can also develop the integration without having extensive technology knowledgebase. They can also work on creating their own integration."
"The solution is easy to manage and offers good integration. You can run all the tasks one by one which is really helpful, and pick the day and time to do so."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"It's on the cloud, so it's scalable and quite easy to work with."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"Having a single vendor supporting the entire suite of applications."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"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 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."
"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."
"The licensing is difficult."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"Lacks ability to calculate cost of the product."
"Bulk uploading can be a problem when you hit the upper limit."
"This is an expensive solution compared to other products on the market."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"It can be made much easier for users. They should be allowed to easily monitor the data extraction and flow, allowing them to observe real-time data flow within the software, making the process straightforward."
"The pricing could be more competitive."
"I would like to see different cloud adapters or connectors in case of integration. When you have Oracle to Oracle, they are good. They have really good connectors, but if it is a different ERP, like Obsidian, that is where they are faced with problems in OIC."
"I've found technical support not very effective. They should work to improve their services."
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Oracle Data Integrator Cloud Service is ranked 20th in Cloud Data Integration with 7 reviews. Informatica PowerCenter is rated 8.0, while Oracle Data Integrator Cloud Service is rated 8.0. 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". On the other hand, the top reviewer of Oracle Data Integrator Cloud Service writes "A well-established product that meets all our specifications in terms of usability". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue, whereas Oracle Data Integrator Cloud Service is most compared with IBM InfoSphere DataStage. See our Informatica PowerCenter vs. Oracle Data Integrator Cloud Service report.
See our list of best Cloud Data Integration vendors.
We monitor all Cloud 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.