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."Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"PowerCenter performs well during data transformation and optimization."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"It has a Data Catalog that uses the Model repository."
"What I like the most is that we have to deal with less while writing the queries."
"The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter."
"The technical support for Informatica PowerCenter is good."
"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."
"Having a single vendor supporting the entire suite of applications."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"Oracle Data Integrator helps us build tables and data marts and allows us to schedule them daily, for nearly real-time data warehousing."
"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."
"It's on the cloud, so it's scalable and quite easy to work with."
"This product is going to decommission in the next couple of years."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"The initial setup is not straightforward. You need expertise to do it."
"I've found technical support not very effective. They should work to improve their services."
"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."
"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."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"This is an expensive solution compared to other products on the market."
"Bulk uploading can be a problem when you hit the upper limit."
"The pricing could be more competitive."
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.