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 are key players in the data integration and replication markets. Oracle GoldenGate holds an edge in real-time data replication, offering rapid data movement and reduced downtime between diverse sources, making it essential for environments demanding instant data availability.
Features: Oracle Data Integrator is known for its comprehensive ELT architecture, supporting a variety of data sources with flexible customization through Knowledge Modules. This feature facilitates diverse integration scenarios with minimal hardware needs. Oracle GoldenGate excels in real-time data replication, providing high-speed data movement suitable for heterogeneous databases. Its simplicity in configuration enables quicker implementation, critical for instant data synchronization needs.
Room for Improvement: Enhancements for Oracle Data Integrator include improved error handling, enhanced REST integration, and iteration ease in multi-user and complex environments. Users are also looking for better integration with external version control systems beyond SVN. For Oracle GoldenGate, streamlining setup and licensing, improving microservices architecture, and offering better monitoring and support could provide significant customer benefits.
Ease of Deployment and Customer Service: Both products are capable of strong on-premises deployments, with Oracle Data Integrator offering cloud-based options for added flexibility. Customer service experiences vary; Oracle Data Integrator's support is described as adequate but occasionally inconsistent, whereas Oracle GoldenGate's setup complexity and cost are highlighted, despite delivering high value when efficiently used. Support quality frequently depends on specific issues and contract terms.
Pricing and ROI: Oracle Data Integrator and Oracle GoldenGate are considered premium solutions, with each having distinct pricing strategies. Oracle Data Integrator's cost is moderate but can be high for smaller enterprises, justifiable by its robust capabilities if the licensing is navigated effectively. Oracle GoldenGate is perceived as expensive but chosen for its real-time replication features, crucial for environments requiring immediate data replication. Both products can offer substantial ROI with significant time savings and operational efficiencies when optimally deployed.
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.4% |
| Other | 96.1% |
| 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.
