Recap: Accomplish Application Integration with Ease Using Oracle Data Integration
By Mala Narasimharajan on Oct 10, 2011
The 2011 Oracle OpenWorld conference has come to a close and it was a great one indeed. Awe-inspiring sessions, packed to full capacity HOLs and tremendous buzz and interest at the Data Integration demo pods. In case you missed it, there was a very interesting session on Thursday morning that covered application integration with a twist. The twist is that the session covered use cases for Oracle Data Integration as it pertained to achieving application integration.
Here's a run down the uses cases that were covered.
The five uses cases of application integation include: Bulk Data Processing for Application Migrations/Upgrades (Oracle Data Integrator), Zero Downtime Migrations/Upgrades (Oracle GoldenGate), Query Offloading (Oracle GoldenGate), SOA-Based Bulk Data Movement (SOA, ODI), and SOA-Based Bulk Data Transformation (SOA, ODI) .
- Bulk Data Processing for Application Migrations/Upgrades: Oracle Data Integrator is used to perform data layer integration and move large volumes of data in bulk and execute data transformations. This scenario is for pure data integration with no process or services level integration involved.
- Zero Downtime Migrations/Upgrades: Many organziations are often looking to upgrade to the most recent version of their particular application, however these upgrade processes typically require downtime, which can disrupt business operations. Oracle GoldenGate removes the need to make invasive changes to the source and target systems by seamlessly moving data in real-time, and phased upgrades can be implemented in a dramatically reduced timeframe.
- Query Offloading: Oracle GoldenGate enables real-time reporting off of a lower cost sytem by keeping a reporting database in sync with the original OLTP system. GoldenGate can move only the data that is required for the purpose of reporting, and heterogeneity assures the use of low cost systems that offload query execution from OLTP systems.
- SOA-based Bulk Data Movement and Transformation: SOA and Oracle Data Integrator work together to accomplish application integration, with each product focused on what they do best. ODI is used for the "heavy data lifting and transformations" and is invoked by Oracle BPEL Process Manager or Oracle Service Bus. Upon completing the data transformations, ODI sends back a response to Oracle BPEL PM and Oracle Service Bus which in turns completes the process level integration. In addition, Oracle SOA Suite and ODI share the same design-time environment in JDeveloper. The benefits of this use case for application integration include: reduced cost of building and maintaining separate integration services and data integrator provides a unified, logical view of the data and enables bulk database/data warehouse loading versus event-by-event loading.
Application Integration is completely addressed when BOTH process-level and data integration are tackled together. Proceeding with one integration over another solves only a portion of the problem and covers only a part of the application architecture. Data is integral to applications as much as exposing application components for integration. As a result, the combination of both data integration and process integration can integrate any resource, whether a web service, data persisted in the database, data in a flat file, business logic in a C application or transactions on a mainframe system.