

Oracle Data Integrator (ODI) and Oracle GoldenGate compete in the data integration and replication category. Oracle GoldenGate appears to have the upper hand with real-time data replication and compatibility with multiple platforms.
Features: Oracle Data Integrator stands out for its powerful ELT architecture, flexibility, and extensive integration capabilities. It supports various data sources without platform dependency and enhances customization through Knowledge Modules. Oracle GoldenGate excels in real-time data replication across heterogeneous systems, offering data synchronization and low-downtime migrations. Its compatibility with Oracle products makes it ideal for real-time processing.
Room for Improvement: ODI users seek improvements in user-friendliness and real-time integration, noting its complexity and steep learning curve. Enhancements in the GUI and error handling are desired, alongside concerns over high licensing costs. Oracle GoldenGate users face challenges with its complexity and setup, calling for better documentation and integration with non-Oracle databases. Improvements in monitoring and support for debugging complexities are also requested.
Ease of Deployment and Customer Service: Both products offer versatile deployment options, supporting on-premises and cloud environments. ODI features various licensing models, including cloud integration, while GoldenGate supports hybrid and private cloud solutions. ODI users report mixed support experiences, noting availability but delays with complex issues. GoldenGate users highlight high licensing costs but appreciate comprehensive support, though it varies by issue complexity and location.
Pricing and ROI: ODI is considered expensive with licensing complexities and regional price disparities, yet valuable for comprehensive integration capabilities, promising good ROI if properly implemented. GoldenGate is viewed as costly, especially due to core-based pricing. However, its unique features justify the expense, proving cost-effective through real-time processing benefits and minimal downtime migrations. Both products offer potential ROI dependent on successful deployment and fit to use case.
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) | 3.0% |
| Oracle GoldenGate | 1.6% |
| Other | 95.4% |


| 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.