Introduction With its version 12, Oracle Data Integrator offers three flavors of agents: JEE, Colocated and Standalone. The purpose of this post is to compare...
Introduction With its version 12, Oracle Data Integrator offers three flavors of agents: JEE, Colocated and Standalone. The purpose of this post is to compare and contrast the benefits of each one of these types of agents and to help developers and architects select the best option(s) for their implementation. ODI Agents: Standalone, JEE and Colocated In this comparison between the three agent flavors, we only refer to the 12c version of ODI unless otherwise noted. Agents...
Introduction With its version 12, Oracle Data Integrator offers three flavors of agents: JEE, Colocated and Standalone. The purpose of this post is to compare and contrast the benefits of each one...
Introduction With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone...
Introduction With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone agent: source, target or middle tier systems? We look here at different possible architectures and provide the best choices accordingly. Understanding Where to Install the ODI Standalone Agent Source, Target or Middle tier? Source systems be dispersed throughout the information system: connection from one source system...
Introduction With no middle tier required in the ODI architecture, the most common question from people who are new to ODI is where to install the standalone agent: source, target or middle...
Introduction Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply provides the ability to spawn multiple OGG Replicat...
Introduction Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply provides the ability to spawn multiple OGG Replicat processes from one parameter file. This article discusses configuration options, GGSCI commands, and troubleshooting for Coordinated Apply as of OGG version 12.1.2.0.0 Main Article OGG 12c introduced the Coordinated Apply; which is a multi-threaded Replicat that performs parallel processing of data into a target database. In...
Introduction Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply provides the ability to spawn multiple OGG Replicat processes from one parameter file. This article...
Introduction This document describes how to convert a primary key update operation into a delete and insert operation based on the customer’s needs. This will...
Introduction This document describes how to convert a primary key update operation into a delete and insert operation based on the customer’s needs. This will be required where data is filtered and sent to different target locations based on the value of the primary key. This document is intended for Oracle Database Administrators (DBAs), Oracle Developers with some basic knowledge of Oracle GoldenGate software and Oracle GoldenGate Administrators. The document is intended to...
Introduction This document describes how to convert a primary key update operation into a delete and insert operation based on the customer’s needs. This will be required where data is filtered...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use the on-device SQLite database to store data locally, for example to cache data or to enable working in off-line mode, the amount of code you have to write quickly increases, and while programming you probably realize that you are repeating the same coding patterns for each web service that you want to call to read or...
Introduction When building ADF Mobile applications that go beyond displaying read-only data, you quickly find yourself programming Java code. If you want to use the on-device SQLite database to store...
Introduction The best option for ODI Changed Data Capture is to leverage Oracle GoldenGate. To understand how to best leverage the out-of-the-box integration...
Introduction The best option for ODI Changed Data Capture is to leverage Oracle GoldenGate. To understand how to best leverage the out-of-the-box integration between ODI and GoldenGate, we will review how ODI handles CDC with an in depth explanation of the JKMs principles, then expand this explanation to the specifics of the ODI-GoldenGate integration. Understanding the ODI JKMs and how they work with Oracle GoldenGate ODI is an ELT product. As such, it does not have its own...
Introduction The best option for ODI Changed Data Capture is to leverage Oracle GoldenGate. To understand how to best leverage the out-of-the-box integration between ODI and GoldenGate, we will review...
Introduction This article presents a modified version of the ODI load knowledge module called LKM Oracle to Oracle (datapump). The ODI load knowledge module...
Introduction This article presents a modified version of the ODI load knowledge module called LKM Oracle to Oracle (datapump). The ODI load knowledge module (LKM) presented in this article has been enhanced with additional options and steps to take advantage of the best features of Oracle Data Pump and Oracle External Tables. Some of the enhancements include data compression, server to server file transport, threads control, and the use of Oracle Optimizer Hints. This...
Introduction This article presents a modified version of the ODI load knowledge module called LKM Oracle to Oracle (datapump). The ODI load knowledge module (LKM) presented in this article has been...
Introduction The Oracle GoldenGate (OGG) Extract option SQLPREDICATE may be used to speed-up the initial load of large tables when the source database is...
Introduction The Oracle GoldenGate (OGG) Extract option SQLPREDICATE may be used to speed-up the initial load of large tables when the source database is Oracle, DB2, SQL Server, or Teradata. In this article we shall discuss the various OGG options for splitting data across multiple initial load Extract groups and demonstrate the effectiveness of each. The scripts and information provided in this article are for educational purposes only. They are not supported by Oracle...
Introduction The Oracle GoldenGate (OGG) Extract option SQLPREDICATE may be used to speed-up the initial load of large tables when the source database is Oracle, DB2, SQL Server, or Teradata. In this...
Introduction Many times when working with customers, we hear "We were told never to use Oracle GoldenGate (OGG) to do initial loads, so how do we load our...
Introduction Many times when working with customers, we hear "We were told never to use Oracle GoldenGate (OGG) to do initial loads, so how do we load our non-Oracle data to Oracle?" It is true that native database utilities can be used to make copies of large databases faster than OGG in a homogeneous (like-to-like) implementation. However, when loading data of dissimilar structure OGG may be the best, and possibly only, data load solution. The key is to use some of the more...
Introduction Many times when working with customers, we hear "We were told never to use Oracle GoldenGate (OGG) to do initial loads, so how do we load our non-Oracle data to Oracle?" It is true...
