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...
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...
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, ODI user functions, and ODI custom knowledge modules. Also, Part II focuses on creating a...
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...
Introduction This article includes step by step instructions on how to implement an early arriving fact using database functions, ODI lookups, ODI user...
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 article. Part I gives you an overview of the proof-of-concept (POC) I created in ODI to implement an early...
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...
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...
Introduction This article demonstrates how to configure Oracle Business Intelligence Enterprise Edition (OBIEE) to invoke Oracle Data Integrator (ODI) web...
Introduction This article demonstrates how to configure Oracle Business Intelligence Enterprise Edition (OBIEE) to invoke Oracle Data Integrator (ODI) web services. In a data warehouse environment where the ETL/ELT tool is ODI and the business intelligence tool is OBIEE, it is common to find the need for BI users to execute ODI scenarios and ODI load plans from OBIEE. BI users with special privileges may want to launch ad hoc jobs to process data for a specific BI task or...
Introduction This article demonstrates how to configure Oracle Business Intelligence Enterprise Edition (OBIEE) to invoke Oracle Data Integrator (ODI) web services. In a data warehouse environment...
Introduction The Oracle GoldenGate Command Interpreter (GGSCI) contains three commands that can be used to reduce the amount of typing required to interact with...
Introduction The Oracle GoldenGate Command Interpreter (GGSCI) contains three commands that can be used to reduce the amount of typing required to interact with the product. These commands come in handy when troubleshooting, monitoring, and configuring large environments; or if, like myself, you are QWERTY keyboard challenged. This article discusses the function and use of the GGSCI History, ! (Bang), and FC (Fix/Change) commands. Main Article Here is an example GGSCI prompt:...
Introduction The Oracle GoldenGate Command Interpreter (GGSCI) contains three commands that can be used to reduce the amount of typing required to interact with the product. These commands come in...
Introduction Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time configuration settings across multiple components and...
Introduction Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time configuration settings across multiple components and externalizing complex configuration settings in order to streamline parameter file contents. In this article we shall discuss how to create a Macro Library and access specific Macros via the OGG Group parameter file. Main Article A Macro Library is a collection of OGG Macros used to externalize OGG parameters shared...
Introduction Oracle GoldenGate (OGG) Macros provide functionality for sharing parameters or other run-time configuration settings across multiple components and externalizing complex...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated Extract(log mining server) comes from the "STREAMS POOL" portion of the System Global Area (SGA) in the database. Therefore, you must set it high enough to keep enough memory available for the number of Extract processes that you expect to run in Integrated mode against a given database instance. Note that "STREAMS POOL" is...
Introduction This document outlines the memory requirement for GoldenGate Integrated Extract. Main Article The shared memory that is used by Integrated Extract(log mining server) comes from the...
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication....
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in this document. Main Article For Oracle GoldenGate (OGG) DDL replication to work correctly, the source and target schemas should be identical. Sometimes even if the sequence of operations used to create the schemas are different, it could impact DDL replication. For example the...
Introduction The way in which a schema is set up and objects are created in the source and target environments could impact Oracle GoldenGate DDL replication. This is illustrated by the example in...
