Introduction Whether you are processing XML files or XML messages on JMS, ODI provides a JDBC driver that will translate the XML structure into a relational...
Introduction Whether you are processing XML files or XML messages on JMS, ODI provides a JDBC driver that will translate the XML structure into a relational schema. By default, this schema is created in an in-memory database. While this approach will work extremely well for small XML files or messages, it can become challenging for larger volumes. In this two part article we are first reviewing how the driver works, then we are detailing the benefits of using an actual...
Introduction Whether you are processing XML files or XML messages on JMS, ODI provides a JDBC driver that will translate the XML structure into a relational schema. By default, this schema is created...
Jayant Mahto from the ODI Product Management team has published an excellent blog explaining how to correlate database sessions with ODI sessions. You can find...
Jayant Mahto from the ODI Product Management team has published an excellent blog explaining how to correlate database sessions with ODI sessions. You can find his post here: https://blogs.oracle.com/biapps/entry/correlating_sql_statement_in_db For more ODI best practices, tips, tricks, and guidance that the A-Team members gain from real-world experiences working with customers and partners, visit “Oracle A-Team Chronicles for ODI”.
Jayant Mahto from the ODI Product Management team has published an excellent blog explaining how to correlate database sessions with ODI sessions. You can find his post...
Introduction Understanding connectivity issues in an ODI environment requires a good grasp of the ODI architecture, as well a good understanding of where to...
Introduction Understanding connectivity issues in an ODI environment requires a good grasp of the ODI architecture, as well a good understanding of where to look for information when such problems arise. We will review all these elements to help with diagnosis and resolution. How to Understand and Diagnose ODI Connectivity Issues We will start with a quick review of the ODI architecture to make sure that all components are in place when we will look for connection issues....
Introduction Understanding connectivity issues in an ODI environment requires a good grasp of the ODI architecture, as well a good understanding of where to look for information when such problems...
Introduction Careful consideration needs to be given to the manner in which files are created and written for (read) processing by the File and FTP Adapters...
Introduction Careful consideration needs to be given to the manner in which files are created and written for (read) processing by the File and FTP Adapters Main Article Note Hereinafter the term "the Adapter" means either the File or FTP Adapter. The abbreviation EA means External Application. General usage of the Adapter The objective of the Adapter (when reading files) is simple - viz. identify file(s) to be read, process the file(s), (optionally) delete the file and...
Introduction Careful consideration needs to be given to the manner in which files are created and written for (read) processing by the File and FTP Adapters Main Article Note Hereinafter the term...
In the real business scenario of integrating SOA/AIA applications with Oracle Business Activity Monitoring (BAM), one common requirement is that such...
In the real business scenario of integrating SOA/AIA applications with Oracle Business Activity Monitoring (BAM), one common requirement is that such integration should not impact the operations of business systems running on SOA/AIA in terms of high availability and performance. To achieve this goal, one option is to use BAM Adapter or BAM Sensor Actions with Batching enabled. This article explains how batching works in Oracle BAM Adapter. Why You Need Batching When talking...
In the real business scenario of integrating SOA/AIA applications with Oracle Business Activity Monitoring (BAM), one common requirement is that such integration should not impact the operations of...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for configuring Oracle GoldenGate (OGG) in an active-active...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for configuring Oracle GoldenGate (OGG) in an active-active environment with DDL replication enabled while also using the built in functionality of DML Conflict Detection and Resolution (CDR). This document is intended for Oracle Database Administrators (DBAs), Oracle Developers with some basic knowledge of Oracle GoldenGate software product and Oracle GoldenGate...
Introduction This document is an introduction to Oracle GoldenGate’s best practices and guidelines for configuring Oracle GoldenGate (OGG) in an active-active environment with DDL replication enabled...
Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial...
Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial provides a quick overview of Oracle to Oracle database replication using Extract and Replicat for version 11.2 and above. Both Classic and Integrated Extract are demonstrated in this tutorial. For more detailed information, please consult the Oracle GoldenGate Administration Guide. This tutorial may be read to get a...
Introduction Extract, Replicat and associated utilities enable you to create, load and refresh one Oracle database to another Oracle database. This tutorial provides a quick overview of Oracle...
Introduction I'm happy to announce that Oracle has just released the Java CAPS Migration Tool under Controlled Availability to Oracle customers and certified...
Introduction I'm happy to announce that Oracle has just released the Java CAPS Migration Tool under Controlled Availability to Oracle customers and certified partners. Oracle customers, partners and consultants can now migrate JCAPS artefacts and intellectual property to Fusion Middleware, often saving several "person decades" of redesign and recoding. What's more, the tooling and methodology cover the most recent versions of the ICAN, JCAPS and JBI releases and support a...
Introduction I'm happy to announce that Oracle has just released the Java CAPS Migration Tool under Controlled Availability to Oracle customers and certified partners. Oracle customers, partners and...
Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will...
Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will depend on the network configuration. This article will elaborate on this very simplistic answer and will help define best practices for the architecture of ODI repositories in a corporate environment. How Many ODI Master Repositories Should We Have? Master and Work Repositories Before delving into the specifics of...
Introduction A question that often comes up is how many Master Repositories should be created for a proper ODI architecture. The short answer is that this will depend on the network...
