We performed a comparison between Informatica Cloud Data Integration, Oracle Data Integrator Cloud Service, and Quest SharePlex 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."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."
"The Mapping Configuration and PowerCenter wizards are valuable. We use them to run our business logic."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"It is one of the best tools available for data integration."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"The features I find most valuable is the synchronization, verification, functionalities and all the data integration features."
"The support is very good."
"It is quite easy to use and flexible."
"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."
"The data is stored in the cloud, making it easy to download data simultaneously into multiple smaller servers, effectively downsizing the process."
"Oracle integration cloud has got the adapters for all their products, which makes integration faster."
"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."
"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."
"It's on the cloud, so it's scalable and quite easy to work with."
"The core replication and its performance. Performance is crucial, and SharePlex is by far the fastest. The way it handles replication to multiple targets along with basic filtering, as well as from multiple sources to a single target, is very efficient."
"There are some capabilities within SharePlex where you can see how the data is migrating and if it still maintains good data integrity. For example, if there are some tables that get out of sync, there are ways to find them and fix the problem on the spot. Since these are very common issues, we can easily fix these types of problems using utilities, like compare and repair. So, if you find something is out of sync, then you can just repair that table. It basically syncs that table from source to target to see if there are any differences. It will then replicate those differences to the target."
"The core features of the solution we like are the reliability of the data transfer and the accuracy of data read and write. The stability of the solution is also excellent."
"Because of the volume of the transactions, we heavily use a feature that allows SharePlex to replicate thousands of transactions. It's called PEP, Post Enhancement Performance, and that has helped us scale tremendously."
"I like SharePlex's Compare and Repair tool."
"Its pricing model can be improved. The response time from technical support can also be improved."
"I would like to see support for more data sources."
"The integration process is not easy."
"With the solution, we had some issues, and we have every day, and we used to open a ticket. Sometimes, there are data issues and transformation issues."
"The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."
"I would like to see more functionality added so that it is a bit closer to how much you can do with Informatica PowerCenter."
"The error information provided is not informative, as compared to Power Center."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"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."
"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."
"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."
"For its function in relation to replication (i.e. filtering), I'd give it a six or seven out of 10. GoldenGate has much more functionality by comparison."
"The reporting features need improvement. It would be very good for users to have a clear understanding of the status of replication."
"I don't know how easy it would be to change the architecture in an already implemented replication. For example, if we have a certain way of architecting for a particular database migration and want to change that during a period of time, is that an easy or difficult change? There was a need for us to change the architecture in-between the migration, but we didn't do it. We thought, "This is possibly complicated. Let's not change it in the middle because we were approaching our cutover date." That was one thing that we should have checked with support about for training."
"I would like more ability to automate installation and configuration in line with some of the DevOps processes that are more mature in the market. That would be a considerable improvement."
"I would like the solution to have some kind of machine learning and AI capabilities. Often, if we want to improve the performance of posting, we have to bump up a parameter. That means we need to stop the process, come up with a figure that we want to bump the parameter up to, and then start SharePlex. Machine learning and AI capabilities for these kinds of improvement would tremendously help boost productivity for us."
More Informatica Cloud Data Integration Pricing and Cost Advice →
More Oracle Data Integrator Cloud Service Pricing and Cost Advice →