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

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

Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

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