Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle GoldenGate 12c (12.3.0.1) Introduction The best option for ODI Changed...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle GoldenGate 12c (12.3.0.1) 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...
Validation Content validated on 5/6/2021 with ODI Version 12.2.1.4.200721.1540 Oracle GoldenGate 12c (12.3.0.1) Introduction The best option for ODI Changed Data Capture is to leverage...
Validation Content validated on 4/16/2021 with ODI Version 12.2.1.4.200721.1540 Oracle Database System 19.7.0.0.0 (DBaaS) Introduction This article presents a...
Validation Content validated on 4/16/2021 with ODI Version 12.2.1.4.200721.1540 Oracle Database System 19.7.0.0.0 (DBaaS) 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...
Validation Content validated on 4/16/2021 with ODI Version 12.2.1.4.200721.1540 Oracle Database System 19.7.0.0.0 (DBaaS) Introduction This article presents a modified version of the ODI load...
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 This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Many times when working with customers, we hear "We...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. 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...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Many times when working with customers, we hear "We were told never to use Oracle GoldenGate...
Introduction With over 90% of internet traffic now coming from mobile devices, there is a huge pressure on companies to make their customer-facing applications...
Introduction With over 90% of internet traffic now coming from mobile devices, there is a huge pressure on companies to make their customer-facing applications suitable for rendering on smart phones and tablets. A-team is involved with a number of customers who are looking for ways to adapt their existing Oracle ADF applications and make them “mobile-enabled” . This article is the third in a series of articles that describe what we learned from the experiences with these...
Introduction With over 90% of internet traffic now coming from mobile devices, there is a huge pressure on companies to make their customer-facing applications suitable for rendering on smart...
Introduction This write up illustrates Oracle GoldenGate's behavior in a distributed file system environment that supports file locking. Oracle GoldenGate(OGG)...
Introduction This write up illustrates Oracle GoldenGate's behavior in a distributed file system environment that supports file locking. Oracle GoldenGate(OGG) is very commonly used in an Oracle RAC environment. When OGG is installed in a distributed file system in a RAC environment, at any given time the OGG processes run in a single node of the cluster. To prevent accidental startup from another node of the cluster while the OGG processes are already running in another node...
Introduction This write up illustrates Oracle GoldenGate's behavior in a distributed file system environment that supports file locking. Oracle GoldenGate(OGG) is very commonly used in an Oracle RAC...
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 illustrates how to implement...
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 illustrates how to implement early arriving facts in Oracle Data Integrator (ODI). This article has two parts. Part I gives you an overview of a proof-of-concept created in ODI to implement an early arriving fact. Part II includes step-by-step instructions on how to implement an early arriving fact using Oracle database functions, ODI lookups,...
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 illustrates how to implement early arriving facts in Oracle Data...
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 includes step by step...
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 includes step by step instructions on how to implement an early arriving fact using database functions, ODI lookups, ODI user functions, and ODI custom knowledge modules. In this article, I focus on creating a reusable solution in ODI that can be utilized for other early arriving facts in your data warehouse. This is Part II of a two-parts...
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 includes step by step instructions on how to implement an early...
Introduction In Part 1 of the B2B Agreement Life-Cycle Management Series, we looked at the best practices to import high volume of agreement metadata into the...
Introduction In Part 1 of the B2B Agreement Life-Cycle Management Series, we looked at the best practices to import high volume of agreement metadata into the repository [1]. In this post, we will take a look at the best practices to deploy the agreement metadata for run-time processing. Background B2B 11g supports the notion of agreements, which serve as the binding contract between different partners and documents defined within the repository. In order to facilitate...
Introduction In Part 1 of the B2B Agreement Life-Cycle Management Series, we looked at the best practices to import high volume of agreement metadata into the repository [1]. In this post, we...
