Oracle Data Integration Platform Cloud (DIPC): Configure VPN as a Service (VPNaaS) for On-Premises Connectivity

Introduction This document will walk you through how to configure Virtual Private Network as a Service (VPNaaS) with Oracle Data Integration Platform Cloud (DIPC) for connectivity between On-Premises Oracle database and Oracle Public Cloud (OPC). One major requirement for DIPC to be configured with VPNaaS is; DIPC must be provisioned to use IP Network instead of […]

Oracle GoldenGate: Apply to Apache Flume File Roll Sink

Introduction Apache Flume is a distributed, reliable, and available system for efficiently collecting, aggregating and moving large amounts of log data from many different sources to a centralized data store. The Oracle GoldenGate for Big Data Flume Handler is designed to stream change capture data from a Oracle GoldenGate trail to a Flume File Roll […]

Oracle GoldenGate Big Data Adapter: Establishing Secure Connections to Apache Kafka

Introduction When publishing data to Apache Kafka via the Oracle GoldenGate Big Data Kafka Handler, it is a good practice to establish secure connections in order to protect sensitive data from un-authorized snooping. The Oracle Big Data Kafka Handler leverages encryption and authentication features built-in to Apache Kafka. In this article we shall detail the Oracle […]

Oracle GoldenGate Big Data Adapter: Apache Kafka Producer

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 […]

Oracle GoldenGate Big Data: Apply to Apache HDFS

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 […]

Connecting Oracle Data Sync to the Exadata Express Cloud using OCI

Introduction This post details the steps required to create connections in Oracle Data Sync to the Exadata Express Cloud 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 (ADWC) and Exadata Express Cloud Service which uses the JDBC Thin driver. For […]

Oracle Data Integrator Best Practices: Performing the Initial Data Load of a Data Warehouse in the Oracle Autonomous Data Warehouse Cloud Service

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 Service (ADWCS). ADWCS is a fully-managed and pre-configured Oracle database cloud […]

Extracting Data from Oracle Analytics Cloud using REST

Introduction This post provides a simple method of extracting data from Oracle Analytics Cloud (OAC) using Business Intelligence Publisher (BIP) REST web services. Refer to REST API for Oracle BI Publisher for details. It builds upon and uses the analysis from the post ‎Extracting Data from Oracle Analytics Cloud using SOAP A key differentiator in OAC and OBIEE […]

Connecting Oracle Data Sync to the Autonomous Data Warehouse Cloud using OCI

Introduction This post details the steps required to create connections in Oracle Data Sync to the Autonomous Data Warehouse Cloud (ADWC) 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 (ADWC) which uses the JDBC Thin driver. For additional details about […]

Connecting Oracle Data Integrator Studio to the Exadata Express Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) to the Exadata Express Cloud. For additional details about Exadata Express, refer to Exadata Express Cloud Service. 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 […]

Connecting Oracle Data Integrator Studio to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create connections in Oracle Data Integrator (ODI) to the Autonomous Data Warehouse Cloud (ADWC). For additional details about ADWC, refer to Autonomous Data Warehouse Cloud. 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 on Windows […]

Oracle GoldenGate extract recovery (Missing archivelogs)

  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 […]

Oracle GoldenGate: DDL Replication To Oracle Targets With Dissimilar Data Structure

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 […]

Creating a Connection in Data Visualization Desktop to the Exadata Express Cloud Service

Introduction This post details the steps required to create a connection in DVD to the Exadata Express Cloud Service. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on Data Visualization Desktop (DVD), visit the Oracle Data Visualization Desktop page. Topics Preparing Windows Preparing Data Visualization Desktop Preparing the Data Warehouse Cloud Service (DWCS) Wallet […]

Connecting an Oracle Analytics Cloud RPD to the Exadata Express Cloud Service

Introduction This post details the steps required to prepare an OAC instance for an RPD with an Exadata Express Cloud Service data source connection. It uses the RPD created with the steps in Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For […]

Creating a Connection in Oracle Analytics Cloud to the Exadata Express Cloud Service

Introduction This post details the steps required to create a connection to the Exadata Express Cloud Service for Data Visualization projects. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Before you Begin Preparing Windows to Upload Files Preparing OAC for an Exadata Express Connection Preparing the […]

Creating a Connection in Oracle Analytics Cloud to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create a connection to the Autonomous Data Warehouse Cloud (ADWC) for Data Visualization projects. For additional details on ADWC, visit the Autonomous Data Warehouse Cloud page. For additional details on OAC, visit the Analytics Cloud page. Topics Before you Begin Preparing Windows to Upload Files Preparing OAC for an ADWC Connection Preparing the DWCS Wallet […]

Connecting an Oracle Analytics Cloud RPD to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to prepare an OAC instance for an RPD with an Autonomous Data Warehouse Cloud (ADWC) data source connection. It uses the RPD created with the steps in Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse Cloud. For additional details about ADWC, visit the Autonomous Data Warehouse Cloud page. For additional […]

Creating an Oracle Analytics Cloud RPD Connection to the Exadata Express Cloud Service

Introduction This post details the steps required to create an Exadata Express data source connection using the OAC Developer Client Tool on Windows. It also prepares a complete RPD ready for uploading to OAC. For additional details on Exadata Express, visit the Exadata Express Cloud Service page. For additional details on OAC, visit the Analytics Cloud page. Topics Preparing Windows for an […]

Creating an Oracle Analytics Cloud RPD Connection to the Autonomous Data Warehouse Cloud

Introduction This post details the steps required to create an Autonomous Data Warehouse Cloud (ADWC) data source connection using the OAC Developer Client Tool on Windows. It also prepares a complete RPD ready for uploading to OAC. For additional details about ADWC, visit the Autonomous Data Warehouse Cloud page. For additional details on OAC, visit the Analytics Cloud page. Topics Preparing […]