Last validation: April 18, 2019 with 12.2.1.3.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on...
Last validation: April 18, 2019 with 12.2.1.3.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous Data Warehouse (ADW). For additional details about ADW, refer to Autonomous Data Warehouse. For additional details about ODI, refer to Oracle Data Integrator Overview. ODI Studio is assumed to be installed and configured. For information on installing ODI visit Installing and Configuring Oracle...
Last validation: April 18, 2019 with 12.2.1.3.0 Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) on Windows to the Autonomous Data...
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...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to enable the OGG heartbeat in an Oracle to Oracle replication environment, demonstrate the additional information made available via heartbeat, and demonstrate how to manage and modify heartbeat across the replication environment. The concepts, scripts and information presented in this article are for educational...
Introduction Oracle GoldenGate (OGG) version 12.2 introduced an automatic heartbeat integrated into the application. In this article we shall demonstrate how to enable the OGG heartbeat in an Oracle...
For other A-Team articles by Richard, click here Introduction In today's data-centric world, the BI professional is often faced with the problem of joining data...
For other A-Team articles by Richard, click here Introduction In today's data-centric world, the BI professional is often faced with the problem of joining data sets from different sources. In a normalized relational database, you can typically just join column A to column B, and be on your way. Unfortunately that's always not the case. Take the following example. In one database we have an employee called Peter Parker. In the other database, we see 4 different rows of data...
For other A-Team articles by Richard, click here Introduction In today's data-centric world, the BI professional is often faced with the problem of joining data sets from different sources. In...
For other A-Team articles about BICS, OAC, and Data Sync, click here Introduction The Data Sync tool provides the ability to extract from both on-premise, and...
For other A-Team articles about BICS, OAC, and Data Sync, 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. I have previously written about the tool's ability to extract data from OTBI, both cloud and on-premise, and to load into BICS or OAC (that article is here). New functionality has...
For other A-Team articles about BICS, OAC, and Data Sync, 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...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation. ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, Apache Pig, and Apache Kafka, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and Cloudera Enterprise Data Hub (CDH). Additionally, ODI can...
Introduction This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Enterprise or High-Availability installation. ODI offers out of the...
