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."
"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."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"Having a single vendor supporting the entire suite of applications."
"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."
"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 features of ODI are the ease of development, you can have a template, and you can onboard transfer very quickly. There's a lot of knowledge modules available that we can use. If you want to connect, for example, a Sibyl, SQL, Oracle, or different products, we don't have to develop them from scratch. They are available, but if it's not, we can go into the marketplace and see if there's a connector there. Having the connector available reduces the amount of hard work needed. We only have to put the inputs and outputs. In some of the products, we use there is already integration available for ODI, which is helpful."
"ODI is a very accessible tool, especially since the mapping functionality has been added."
"It's completely user-friendly."
"ODI significantly improves data integration and management by allowing customization of data types from various sources like SQL Server databases."
"The most valuable features of ODI are the knowledge modules, such as the Loading Knowledge module and the Check Knowledge module, they are helpful. We can check for the constraints in ODI. That helps in figuring out what are the constraints that are the primary keys created in the tables. We can check them with the Check Knowledge module."
"One of the standout features of ODI is its ability to prepare everything on a vertical level and create reusable components, which adds to its value."
"The product has an ELT approach."
"It is an ETL tool, which does the extract, transform, and load."
"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)."
"It's lacking a lot of mapping features that Oracle OSB and SOA have. It needs to evolve a lot."
"Bulk uploading can be a problem when you hit the upper limit."
"The pricing could be more competitive."
"This is an expensive solution compared to other products on the market."
"I've found technical support not very effective. They should work to improve their services."
"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."
"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."
"The solution lacks some functions and features."
"In our company, we haven't tried consuming services from IoT in our company yet, and I would like to know if the solution will support IoT services in the next release."
"The price needs to be lowered. It's too expensive."
"We used a third party to do the implementation of ODI."
"It lacks a suite of tools suitable for fully processing data and moving it into decision support warehouses."
"Stability could be improved because some operators have issues."
"An area for improvement would be the lack of SQL compatibility - ODI has no ability to interact with SQL unstructured types and data types."
"If you have something like Cisco on top of it, you will have endless problems."
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →
Earn 20 points