Introduction Apache Kafka is a distributed, partitioned, replicated commit log service that provides the functionality of a Java Messaging System. The Oracle...
Introduction 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 Kafka Handler, configure data apply from Oracle 12c tables, and show examples of the different big data...
Introduction 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...
Introduction Oracle GoldenGate for Big Data provides runtime, pluggable functionality into the Oracle GoldenGate Java Delivery framework in order to stream...
Introduction 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 Multi-tenant Database into Apache HDFS. This document covers functionality present in Oracle...
Introduction 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,...
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...
Introduction This post details the steps required to create connections in Oracle Data Sync to the Autonomous Data Warehouse Cloud (ADW) using the JDBC Oracle...
Introduction This post details the steps required to create connections in Oracle Data Sync to the Autonomous Data Warehouse Cloud (ADW) using the JDBC Oracle Call Interface (OCI) driver. It is a companion and alternative to the A-Team post Data Sync and the Autonomous Data Warehouse Cloud (ADW) which uses the JDBC Thin driver. For additional details about ADW, refer to Autonomous Data Warehouse Cloud. Data Sync is assumed to be installed and configured. For information...
Introduction This post details the steps required to create connections in Oracle Data Sync to the Autonomous Data Warehouse Cloud (ADW) using the JDBC Oracle Call Interface (OCI) driver. It is a...
Last validation: April 18, 2019 with 12.2.1.3.0 and ADW 18.4.0.0 Introduction This post details the steps required to create connections in Oracle Data...
Last validation: April 18, 2019 with 12.2.1.3.0 and ADW 18.4.0.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous Data Warehouse (ADW). It is a companion to Connecting DIPC ODI Studio to the Autonomous Data Warehouse which uses ODI Studio in the Data Integration Platform Cloud (DIPC) and Connecting Oracle Data Integrator Cloud Service to the Autonomous Data Warehouse which uses ODICS on...
Last validation: April 18, 2019 with 12.2.1.3.0 and ADW 18.4.0.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous...
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 Oracle GoldenGate for Oracle Databases provides for the replication of DDL operations. In most environments DDL replication is used only where the...
Introduction 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 demonstrate the use of Oracle GoldenGate coupled with the Oracle Database DBMS_STREAMS.SET_TAG...
Introduction 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...
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,...
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 BI Cloud Service (BICS), Oracle Analytics Cloud Service (OAC), and other relational databases. In the latest release, the tool adds the ability to both load into, and extract from, the Autonomous Data Warehouse Cloud (ADWC). This article will walk through the steps to set up the connection to...
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 BI Cloud...
Introduction Oracle GoldenGate (OGG) supports DDL capture and apply for the Oracle and MySQL databases only. Because of this, maintenance tasks for other...
Introduction 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 techniques discussed may also be used for other databases supported by OGG. The concepts,...
Introduction 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...