Sep 09, 2021
We have experiences only in Pentaho Data Integrator (open source competitor of the Oracle Data Integrator).
But OLAP exporting wasn't in our scope until now.
Oracle Data Integrator and Oracle GoldenGate both play important roles in data management, with ODI excelling in EL-T functions, while GoldenGate shines with real-time data replication. ODI seems to have an edge in comprehensive data integration functionalities.
Features: Oracle Data Integrator is effective for complex data integration tasks, offering advanced features such as the ability to handle slowly changing dimensions and strong EL-T capabilities by utilizing database technologies. Users benefit from its flexibility and extensive technology support. Oracle GoldenGate specializes in real-time data replication, excelling in change data capture and supporting heterogeneous systems, providing robust integration without the full EL-T scope found in ODI.
Room for Improvement: ODI users suggest enhancements in the GUI and better integration with external tools, as well as more intuitive error handling. Oracle GoldenGate could improve its user interface, real-time monitoring, and simplify integration processes. Its pricing model is also frequently pointed out as an area needing adjustment.
Ease of Deployment and Customer Service: Both products support multiple deployment options, with ODI more geared towards on-premises setups and GoldenGate offering additional cloud support. While customer service reviews vary, users note the high cost associated with Oracle GoldenGate's support, and both products face challenges in multi-technology environments.
Pricing and ROI: ODI's pricing, suitable for larger enterprises, tends to be high but can offer good ROI when used effectively. Oracle GoldenGate's core-based licensing model is also costly; however, for organizations needing robust real-time replication, the benefits can outweigh the costs if implemented strategically.
The technical support of Oracle is very good; they support the Oracle Data Integrator (ODI) solution effectively.
I can get solutions quickly, and any tickets I submit to Oracle are responded to and resolved rapidly.
The rating for Oracle GoldenGate support is a three.
The support team responds quickly, providing feedback which we then implement.
The scalability and the ability to handle multiple workloads of several parallel ETL jobs could use improvement.
It effectively manages larger databases, such as those of 15 terabytes and above.
In terms of performance stability, I have not experienced any downtimes, crashes, or performance issues with the Oracle Data Integrator (ODI).
Oracle GoldenGate is quite stable.
Integrating AI with ODI that provides recommendations on how to fix those data quality issues after analyzing and profiling business data would be excellent.
If I use a source system like Oracle and a target system like Teradata, ODI will still run, but it struggles a bit with different infrastructures.
Adding AI capabilities would make Oracle Data Integrator (ODI) even better.
The configuration process could be made simpler.
You can tune Oracle GoldenGate to use more RAM on the source side or more processes.
For Oracle GoldenGate, customers face challenges with patching, the latest updates, and encountering bugs.
ODI is cheaper compared to Informatica PowerCenter and IBM DataStage.
The pricing aspect of Oracle Data Integrator (ODI) is reasonable; it brings significant value to the table.
The list price is high, and the price can sometimes seem expensive if the appropriate discount is not applied.
The pricing of Oracle GoldenGate is quite high.
The main benefits that Oracle Data Integrator (ODI) brings to the table include data quality, data completeness functionality, metadata management, and the reverse engineering feature, which allows integrating the metadata of diversified data sources with a single click.
Oracle Data Integrator (ODI)'s ELT architecture has helped optimize my data movement and transformation significantly.
Oracle Data Integrator (ODI) is powerful and strong if my system uses Oracle components for environments like OLTP, enterprise data warehouse, or data marts.
The ability to sync data in real time is a key feature I rely on.
The benefit is the possibility to use only one tool to perform streaming and transformation of data.
Active Data Guard is an important feature for disaster recovery site applications.
| Product | Mindshare (%) |
|---|---|
| Oracle Data Integrator (ODI) | 2.5% |
| Oracle GoldenGate | 1.5% |
| Other | 96.0% |
| Company Size | Count |
|---|---|
| Small Business | 26 |
| Midsize Enterprise | 12 |
| Large Enterprise | 44 |
| Company Size | Count |
|---|---|
| Small Business | 22 |
| Midsize Enterprise | 5 |
| Large Enterprise | 30 |
Oracle Data Integrator offers flexible EL-T architecture, optimizing processing with database capabilities. It supports diverse data sources, automates deployment, and provides efficient data transformations, making it suitable for data warehousing and complex data environments.
Oracle Data Integrator leverages EL-T architecture to enhance processing by utilizing database strengths. It integrates with a wide array of technologies, including RDBMS, cloud, and big data. The software's Knowledge Modules enable customizable integration strategies, accelerating development. With a user-friendly interface and automation features, it simplifies metadata management and supports real-time data warehousing. Key areas such as UI performance, integration, and real-time data capabilities require enhancements. Challenges include error handling, initial setup, and compatibility with platforms like Git, Azure, and IoT services. Improvements in metadata management, scalability, and user-friendliness are needed.
What are the most important features of Oracle Data Integrator?Organizations utilize Oracle Data Integrator primarily in data warehousing, handling data from ERP systems, EBS, Fusion, and cloud databases. It aids in creating data lakes, OLTP migrations, digital health initiatives, and automation tasks, ensuring seamless integration with databases like MySQL and SQL Server.
Oracle GoldenGate offers seamless data replication and real-time data transformation, supporting heterogeneous databases with ease. It's appreciated for its stability, scalability, and the capability to handle large data volumes efficiently.
Oracle GoldenGate is known for its effective real-time data integration and minimal downtime, making it suitable for high-volume transactions. While praised for its compatibility across platforms and cost-effectiveness, it faces challenges with cost, licensing, and non-Oracle database integration. Its graphical interface and documentation require enhancements, and technical support could be more responsive. Advanced users seek refined API features and improvements in scalability. Despite these, it remains popular for supporting disaster recovery, data integration, and real-time data exchange.
What are the most important features of Oracle GoldenGate?Oracle GoldenGate is extensively used within industries such as finance and government for data migration, supporting zero-downtime migrations and cloud shifts. These sectors utilize it for centralizing diverse data sources, aiding analytics, and ensuring high availability through disaster recovery solutions.
We monitor all Data Integration 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.
