We performed a comparison between Informatica Cloud Data Integration and Oracle Data Integrator (ODI) 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."We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"Replication allows us to fully replicate all objects from Shop Floor Data Collection (SFDC) to in-house/on-premises database in one job."
"The product improves data quality."
"The mass ingestion functionality and the elasticity of the solution are great."
"The solution has the best feature for parameterization."
"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"I do not have to maintain a separate ETL instance. I can change the SQL when something is not performing correctly."
"Oracle provides great documentation."
"It's completely user-friendly."
"The most valuable feature of ODI is the to use of the whole ETL to create a data lake."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It can integrate with more recent databases like Cassandra, Hadoop, and other more recent Big Data databases."
"It is an ETL tool, which does the extract, transform, and load."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"User/group administration could use improvement."
"Certain shortcomings in the product's UI make it an area where improvements are required."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
"Its pricing model can be improved. The response time from technical support can also be improved."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"I would also like to have profiling functionalities and quality transformations in the cloud."
"There may be some types of limitations with the performance."
"The performance of the user interface is in need of improvement."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"The initial setup is a bit complex compared to other tools."
"Oracle Data Integrator (ODI) is already good as a solution. Still, it needs some editing of its preview package, or if the package is upgraded, that will make Oracle Data Integrator (ODI) even better."
"If you have something like Cisco on top of it, you will have endless problems."
"There are certain things where it can be improved. Initial solution setup seems a bit complex at the start, it should be improved because it becomes bit tough for a novice to get started on this. Sometimes error description is not helpful to understand the problem it gives some generic type of errors which are at times not that helpful to understand the underlying root cause of the issue."
"Overall the product is fine, but sometimes its reports unknown errors while we compile ETL scripts."
"Reverse engineering is complicated and challenging to manage."
More Informatica Cloud Data Integration Pricing and Cost Advice →
Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews while Oracle Data Integrator (ODI) is ranked 4th in Data Integration with 67 reviews. Informatica Cloud Data Integration is rated 7.8, while Oracle Data Integrator (ODI) is rated 8.2. The top reviewer of Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". On the other hand, the top reviewer of Oracle Data Integrator (ODI) writes "Straightforward to implement, scalable, and has good stability and documentation, but technical support could still be improved". Informatica Cloud Data Integration is most compared with Informatica PowerCenter, Azure Data Factory, AWS Glue, Fivetran and Mule Anypoint Platform, whereas Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, SSIS, Informatica PowerCenter, Azure Data Factory and Oracle GoldenGate. See our Informatica Cloud Data Integration vs. Oracle Data Integrator (ODI) 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.