Oracle Data Integrator - used for data consolidation and integration project.
Anonymous | TrustRadius Reviewer
December 13, 2018

Oracle Data Integrator - used for data consolidation and integration project.

Score 9 out of 10
Vetted Review
Verified User
Review Source

Overall Satisfaction with Oracle Data Integrator

Oracle Data Integrator was used along with Oracle Goldengate product to consolidate data into Oracle database from other data resources in other DBMS and ETL jobs. The data was integrated or converted into using target format using Oracle Data Integrator.
  • Converts data from various sources into one target format using various business logic rules and integrates with various DBMS types.
  • Transformed data from DB2, SQL Server and other Oracle databases into flat files and then used ETL jobs to load into Oracle DB target
  • Data Integrator and Goldengate were used together to accomplish the data movement needed for business and data consolidation in live environment. Data Integrator helped with development and in reducing lead time to convert data into target.
  • Still complex product to use for ETL developers. Needed lot of training and testing before it could be implemented in production data conversion.
  • Initial set up was resource intensive on machine and manpower used on this project.
  • Better GUI interface with less options should be designed for Big data integration tool.
  • Lead time to complete data integration and transformation project was reduced due to Oracle Data Integrator tools that helped in setting up transformations relatively quickly once it was set up.
  • Reduced lead time helped in reducing project cost as less resources were spent in data conversion project.
  • Overall data consolidation project resulted in quick integration of data from varied DBMS and data sources.
Yes - I am a member of the Dallas Oracle Users Group.

The experience of DOUG members helped in determining impact of Oracle Data Integrator on similar projects. It also helped in making the decision to use ODI. When issues came up and when quick help was needed, the DOUG member's experience helped in resolving the issues.
Chose Oracle Data Integrator for its compatibility and integration with Oracle Goldengate
Well suited for data consolidation into data warehouse type of database from multiple sources in real time.