Why Oracle Data Integrator


1. ELT architecture provides high performance.
– ELT faster than ETL
2. Active integration enables real-time data warehousing and operational data hubs.
– Changed data capture technology for real-time data warehousing
– Data services provided to the Oracle SOA Suite
3. Declarative design improves developer productivity.
– Business users specify what they want; ODI generates the flows and code.
4. Knowledge modules provide flexibility and extensibility.
– Predefined, reusable code templates with built-in connectivity to all major databases
1.  ODI’s ELT architecture leverages disparate RDBMS engines to process and transform  the data. This approach optimizes performance and scalability and lowers overall solution costs.
2.  ODI turns the promise of active integration into reality by providing all key components required to enable real-time data warehousing and operational data hubs. ODI combines three styles of data integration: data based, event based, and service based. ODI unifies silos of integration by transforming large volumes of data in batch, by processing events in real time through its advanced Changed Data Capture, and by providing data services to the Oracle SOA Suite.
3.  Oracle Data Integrator shortens implementation times with its declarative design approach. Designers specify what they want to accomplish with their data, and then the tool generates the details of how to perform the task. With ODI, the business user or the developer specifies the rules to apply to the integration processes. The tool automatically generates data flows and administers the correct instructions for the various source and target systems. With declarative design, the number and complexity of steps is greatly reduced, which in turn shortens implementation times. Automatic code generation reduces the learning curve for integration developers and streamlines non-IT professionals to the definition of integration processes and data formats.
4. Knowledge modules are at the core of the ODI architecture. They make all ODI
processes modular, flexible, and extensible. Knowledge modules implement the actual data flows and define the templates for generating code across the multiple systems involved in each process. ODI provides a comprehensive library of knowledge modules, which can be tailored to implement existing best practices (for example, for highest performance, for adhering to corporate standards, or for specific vertical know-how). By helping companies capture and reuse technical expertise and best practices, ODI’s knowledge module framework reduces the cost of ownership. It also enables metadata-driven extensibility of product functionality to meet the most demanding data integration challenges.
    ODI 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


No comments:

Post a Comment