Wednesday, 19 March 2014

What, Who and Why of Oracle Data Integrator

What is Oracle Data Integrator
Oracle Data Integrator streamlines the high performance movement and transformation of data
between heterogeneous systems in batch, real time, synchronous, and asynchronous modes; it
dramatically enhances user productivity with an innovative, modularized design approach and
built-in connectivity to all major databases, data warehouse appliances, analytic applications and
SOA suites.

Oracle Data Integrator includes graphical modules and software agents that allow you to:
• Reverse engineer application models.
• Check data consistency.
• Design, test, operate and maintain interfaces between applications.
• Check the data flows processed by the interfaces, with error isolation and/or recycling.
• Identify missing data input.

Who is Oracle Data Integrator designed for? 
Most of the Oracle Data Integrator modules are designed for computer specialists (project
managers, programmers, data administrators, etc), who are involved in an application interfacing
project. These are people who:
• Have a complete functional knowledge of all source and/or target applications
• Are responsible for operating interfaces

Why Oracle Data Integrator? 
IT solutions dedicated to a job function are becoming more frequent in companies.
In this context, data must be synchronized throughout the company Information System.
With Oracle Data Integrator, you can:
• Increase the productivity of projects involving data transfer and/or transformation. These
   projects include migration, installation of packages, construction of secured databases for the
   Internet, installation of data warehouse and data marts, and synchronization of heterogeneous
   applications.
• Improve the quality of the company's data, in both old IT applications and new ones.
• Improve inter-application dialog by having interfaces executed asynchronously.