Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Apache Kafka is a distributed, partitioned,...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Apache Kafka is a distributed, partitioned, replicated commit log service that provides the functionality of a Java Messaging System. The Oracle GoldenGate for Big Data Kafka Handler acts as a Kafka Producer that writes serialized change capture data from an Oracle GoldenGate Trail to a Kafka Topic. In this article we will setup the Oracle GoldenGate Big Data...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Apache Kafka is a distributed, partitioned, replicated commit log service that provides the...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Big Data provides runtime,...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle GoldenGate Java Delivery framework in order to stream transactional data into big data systems, raising the quality and timeliness of business insights. In this article we shall setup the Oracle GoldenGate Apply mechanism (Replicat) to stream data captured from an Oracle 12c...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle Data Integrator (ODI) - to perform the initial data load of a data warehouse in the Oracle Autonomous Data Warehouse Cloud (ADWC). ADWC is a fully-managed and pre-configured Oracle database cloud service that is tuned and optimized for data warehouse workloads. As an autonomous cloud service, ADWC does not require...
Introduction This article discusses the best practices that users should follow when using Oracle Data Integration Platform Cloud (DIPC) - specifically Oracle Data Integrator (ODI) - to perform...
Note: This post has been retired as it pertained to an unsupported technology.
This blog has been retired. Please see...
This blog has been retired. Please see https://docs.oracle.com/en/middleware/fusion-middleware/data-integrator/12.2.1.3/odimp/getting-started-oracle-cloud-marketplace.html#GUID-1793F6A6-8581-465D-BBE3-8F0C8ADD6536 for the new ODI Marketplace usage.
Issue description: The issue occurs when archive logs that are needed by Oracle GoldenGate extract gets deleted. For example this can happen when purging old...
Issue description: The issue occurs when archive logs that are needed by Oracle GoldenGate extract gets deleted. For example this can happen when purging old archive logs using RMAN with “force” option. RMAN is integrated with OGG so under normal circumstances RMAN never deletes an archive log that is required by OGG extract. But with “force” option it does delete archive logs required by OGG extract. Although it is certainly not the best practice to use “force” option...
Issue description: The issue occurs when archive logs that are needed by Oracle GoldenGate extract gets deleted. For example this can happen when purging old archive logs using RMAN with “force”...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the source and target tables structures are the same. The challenge comes when the source and target tables have a dissimilar table structure; as may exist in a Data Warehouse or Reporting Database. In this article we shall...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and cloud data sources, and to load that data into a variety of data sources such as Oracle Autonomous Data Warehouse (ADW). This article will walk through the steps to set up the connection to ADW, and show how to create a...
* This blog was last tested on Oracle Analytics Cloud Data Sync (2.6.1) + ADW 18c by Jay Pearson (Oracle A-Team) * For other A-Team articles by Richard, click here Introduction The Data Sync tool...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) supports DDL capture and...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other databases require a lot of coordination and typically an extended OGG outage. In this article we shall discuss one option for automating the capture, delivery, and execution of DDL operations using OGG for Microsoft SQL Server. The...
Introduction This article is applicable to Oracle GoldenGate Classic installations, version 19c and prior. Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases...