Oracle Data Integrator (ODI)

What is Oracle Data Integrator?

The ODI can be integrated as a plug-in of the Oracle Fusion Middleware application server (OBIEE, Hyperion Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning) or fitted as a separate tool which sits on top of (usually but not necessarily) an Oracle database.

Data integration provides a common, reliable method of linking, transforming and managing various forms of information for procedures such as planning, forecasting and budgeting. It is the foundation for many IT initiatives including big data analytics, modernisation and cloud computing.

What does Oracle Data Integrator provide to the end user?

Oracle has constructed a layered suite of technology that delivers universal and timely access to trusted data across diverse systems.

Do you require:

• real-time, bulk data integration or movement,
• data transformation,
• bidirectional replication,
• data services,
• data virtualisation or data quality;

Oracle Data Integrator holds the answers.  The main purpose of ODI is to deliver the ETL functionality; copying structured data from point A to point B, with optional transformations in between.

Data integration technology gives you a common, consistent way to aggregate, link, transform and manage all types of data, from any source, in order to achieve continuous access to trusted data across heterogeneous systems. This data allows top level to obtain a more complete picture of the business and is a must-have technology for innovative IT environments.

ETL = Extract – Transform – Load

ODI ensures data is uninterruptedly available, error-free, and up to date.

Oracle Data Integrator capabilities include real-time and bulk data movement, transformation, bidirectional replication, data quality, big data integration, data storage, management, analysis and presentation for customer and product domains; so that you can quickly extract value from big data with integrated analytics.

Data integration solutions can also address data migration challenges such as the risk of lost or poor quality data. ODI allows uninterrupted operations and improved data quality while moving the data to the new environment.

Deployment:

ODI provides a convenient method of promoting components between environments. Strict internal integrity checks and detailed deployment reports allow for efficient and robust deployments.

Benefits:

• ODI reduces the risk of data migration and data quality during system upgrades. In turn, is reduced the cost of maintaining legacy IT environments while enhancing business insight.
• ODI can be integrated with all of the Oracle Fusion Middleware servers, including OBIEE, Hyperion Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning; enhancing Planning, Budgeting and Forecasting processes within an organisation; as well as over 50 data technologies.
• ODI executes transformations at the database level, making use of fast set operations and minimizing hardware requirements for ODI agents.
• ODI offers great flexibility around meta-data processing. The same code works with different source and target data structures which allows for effective implementation of enterprise-wide data standards.
• ODI allows the implementing custom solutions for each pair of source technology and target technology resulting in the best possible data flow performance for each set of data technologies.

Codec Oracle Data Integrator Implementation service can be adapted to your organisation’s deliverables and with over 30 years’ experience, Codec is well positioned to assist you for all phases for your system implementation.

If you need more information on Oracle Business Intelligence Solutions or would like to arrange a consultation, please feel free to email info@codecdss.co.uk or call us on +44 (0) 207 8732 198