Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps required to enable Oracle Partition Exchange in Oracle Data Integrator (ODI). The article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to upload data, by partition or subpartition, into a partitioned table of an Oracle database. This KM...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article describes the steps required to enable Oracle Partition Exchange in...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration recipe on how to use Oracle Partition Exchange with Oracle Data Integrator (ODI) to upload data very fast into partitioned tables of a large Oracle data warehouse. This article features a new ODI knowledge module (KM), the IKM Oracle Partition Exchange Load, which uses the Oracle Partition Exchange technology to...
Validation Content validated on 5/5/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction This article presents a data integration recipe on how to use Oracle Partition...
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created....
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created. In this article, we shall attempt to demystify this error message. Main Article Bad column index errors tend to occur in OGG heterogeneous; i.e., unlike database, environments and most frequently where change control procedures do not require an OGG sign-off for database maintenance tasks. To demonstrate, I have an...
Introduction The "OGG-01161 Bad Column Index" error is possibly one of the most reviled and misunderstood Oracle GoldenGate (OGG) error messages ever created. In this article, we shall attempt...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Logdump is a standard utility that comes with the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Logdump is a standard utility that comes with the Oracle GoldenGate (OGG) application. Logdump enables the user to view and scan for transactions and records, obtain transaction statistics, and save data contained within OGG Trails. In this article we shall present examples of the Oracle GoldenGate Log File Dump Utility version 12.1.2 functionality that aid in...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Logdump is a standard utility that comes with the Oracle GoldenGate (OGG)...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) provides a mechanism for...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time. In this article we shall discuss this feature and show you how to reference operating system variables from within an OGG parameter file. Main Article Typically when we create OGG Groups we edit a parameter file and define configuration options. This requires that we edit the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) provides a mechanism for assigning values to parameters at run time....
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in the outgoing message. The purpose is to hide the sensitive data in the payload, in the audit trail, console and logs. Main Article Oracle provides Oracle Web Services Manager (OWSM) message protection, but it encrypts the entire payload. However, Oracle OWSM gives us the capability to...
Introduction This article explains how to encrypt sensitive data (such as ssn, credit card number, etc ) in the incoming payload and decrypt the data back to clear text (or original form) in...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With its version 12, Oracle Data...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 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...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With its version 12, Oracle Data Integrator offers three flavors of agents:...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With no middle tier required in the ODI...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 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...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle DB System 19.7.0.0 Introduction With no middle tier required in the ODI architecture, the most common question...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12c introduced the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) version 12c introduced the Coordinated Apply. Coordinated Apply...
