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 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...
