We performed a comparison between Actian Pervasive Data Integrator [EOL], Oracle Data Integrator Cloud Service, and Oracle Data Integrator (ODI) based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), MuleSoft, Matillion and others in Cloud Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"It's on the cloud, so it's scalable and quite easy to work with."
"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 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."
"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."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"The installation of the client ODI Studio is easy."
"It's completely user-friendly."
"It is an ETL tool, which does the extract, transform, and load."
"Easy to understand, very developer-friendly, and has a big forum community and lots of documentation for support."
"Besides loading data, we do most of our transformations in ODI."
"ODI's best features are customization, integration with other versioning tools, and the ability to define new knowledge modules."
"It has the ability to easily load slowly changing dimensions."
"The product has an ELT approach."
"I am not sure if there are various connectors available in the recent version of Pervasive DI to support the wide range of sources available (e.g., big data, cloud, EME)."
"Bulk uploading can be a problem when you hit the upper limit."
"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."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"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."
"This is an expensive solution compared to other products on the market."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"The solution lacks some functions and features."
"The initial setup is a bit complex compared to other tools."
"If there was an add-on tool to hide the performance issues and solve them for me, then I might be interested in that as it would provide me value."
"I would only point out some minor bugs or glitches in the development interface (ODI studio)."
"It has been very good. Just recently, I've faced an issue, but I solved it somehow. While integrating with a file, I faced an issue where I wanted output files, and I had used the text field limited quotations, but at the end of the file, there was a line breakage for the last column. So, we just removed the text field because it was not working correctly for us."
"ODI could improve by focusing on streamlining its features without unnecessary overhead."
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →
Earn 20 points