We performed a comparison between Actian Pervasive Data Integrator [EOL], Informatica PowerCenter, and Oracle Data Integrator Cloud Service based on real PeerSpot user reviews.
Find out what your peers are saying about Microsoft, Informatica, Oracle and others in Data Integration."There were no concerns with the stability. This product is very good from a stability perspective."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"It has very good monitoring and process monitoring."
"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."
"I like the completeness of the way I can build ETL workflows."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"The setup is very simple."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"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."
"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 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."
"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)."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"I would like to see it be able to import data from NoSQL."
"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."
"Support could be better."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"I've found technical support not very effective. They should work to improve their services."
"The pricing could be more competitive."
"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."
"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."
"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."
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →
Earn 20 points