Rodrigo Radtke De SouzaSolutions Architect at a tech consulting company
Abhijit Arun GujareSr. Oracle DBA at a comms service provider
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"All ETL code is stored in repositories in underlying database schemas. The number of users can access and work on the same solution using a client tool. So distributed teams can work on this tool in an efficient manner."
"The scalability is great. It's one of the reasons we chose the solution."
"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."
"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."
"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."
"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."
"The resource management aspect of the solution could be improved."
"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 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."
"It is not as expensive as Oracle GoldenGate and has worked really well within our budgets."
"It's really good value for the money. There are some things they could improve on, but in terms of the pricing, features, and support, as a holistic package, we are not thinking of anything else at this point in time."
Oracle Data Integrator is a comprehensive data integration platform that covers all data integration requirements: from high-volume, high-performance batch loads, to event-driven, trickle-feed integration processes, to SOA-enabled data services. Oracle Data Integrator (ODI) 12c, the latest version of Oracle’s strategic Data Integration offering, provides superior developer productivity and improved user experience with a redesigned flow-based declarative user interface and deeper integration with Oracle GoldenGate.
ODI12c further builds on its flexible and high-performance architecture with comprehensive big data support and added parallelism when executing data integration processes. It includes interoperability with Oracle Warehouse Builder (OWB) for a quick and simple migration for OWB customers to ODI12c. Additionally, ODI can be monitored from a single solution along with other Oracle technologies and applications through the integration with Oracle Enterprise Manager 12c.
SharePlex database replication empowers your organization to achieve its database goals now and into the future. Make use of built-in monitoring, conflict resolution, data comparison and synchronization capabilities backed by award-winning support.
Oracle Data Integrator (ODI) is ranked 6th in Data Integration Tools with 5 reviews while Quest SharePlex is ranked 17th in Data Integration Tools with 3 reviews. Oracle Data Integrator (ODI) is rated 8.8, while Quest SharePlex is rated 9.4. The top reviewer of Oracle Data Integrator (ODI) writes "I have used it to improve run-times of many corporations' overall integration run-times". On the other hand, the top reviewer of Quest SharePlex writes "Real-time replication means our data is available almost instantaneously if an issue occurs in one of our data centers". Oracle Data Integrator (ODI) is most compared with Oracle Integration Cloud Service, Informatica PowerCenter, SSIS, Oracle GoldenGate and IBM InfoSphere DataStage, whereas Quest SharePlex is most compared with Oracle GoldenGate, Qlik Replicate, HVR Software, AWS Database Migration Service and SSIS. See our Oracle Data Integrator (ODI) vs. Quest SharePlex report.
We monitor all Data Integration Tools 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.