Oracle GoldenGate: Integrated Heartbeat

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

UTL_Match and Soundex for ‘Fuzzy’ Matching of Data in an Oracle Database

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

Using Date Based Partitioning for OTBI Extracts with Data Sync to Improve Performance

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

Configuring Oracle Data Integrator for Oracle Big Data Cloud: High-Availability Configuration

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

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Standalone Configuration

Introduction   This article discusses how to configure Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) using the ODI Standalone 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:  […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Environment Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC) – specifically – how to configure the BDC environment for ODI, so users can design Big Data workloads with ODI and execute them on BDC.  ODI offers out of the box integration with Big Data technologies […]

Configuring Oracle Data Integrator for Oracle Big Data Cloud: Topology Configuration

Introduction   This article discusses how to configure the Oracle Data Integrator (ODI) for Oracle Big Data Cloud (BDC), specifically – how to configure the ODI Topology.  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 […]

Using Oracle Data Integrator with Big Data Cloud

Introduction   This article presents an overview of how to use Oracle Data Integrator (ODI) with Oracle Big Data Cloud (BDC). ODI offers out of the box integration with Big Data technologies such as Apache Hadoop, Apache Spark, Apache Hive, and Apache Pig, among others. ODI supports both distributions of Hadoop: Hortonworks Data Platform (HDP), and […]

GoldenGate Cloud Service (GGCS): Replication from On-Premises to Oracle Public Cloud (OPC) via Oracle Cloud Gateway VPN

Introduction This document will walk you through how to configure Oracle GoldenGate (OGG) replication between On-Premises Oracle Database to an Oracle Database Cloud Service (DBCS) on Oracle Public Cloud (OPC) via Oracle Cloud Gateway Virtual Private Network (VPN) using Corente Services Gateway. Installation of Oracle GoldenGate for Oracle Database on the On-Premises and the provisioning […]

Oracle GoldenGate: Data Replication to DBCS via Mid-Tier Server

Introduction Oracle GoldenGate may be used to apply transactional data into, and extract transactional data from, the Oracle Database Cloud Service (DBCS). In this article we shall demonstrated the remote capture and apply of transactional data between an on-premises Oracle Database and DBCS via a mid-tier server running Oracle GoldenGate (OGG). The concepts presented in […]

Oracle GoldenGate: Security Best Practices

Introduction Securing platforms, applications, and data from unauthorized access is of great importance to IT organizations. In this article we shall detail the product features and best practices for securing your Oracle GoldenGate environment. The concepts presented in this article are for educational purposes only. Before applying any changes presented in this article to your environment, […]

GoldenGate Cloud Service (GGCS): Network Connectivity Options for GGCS – On-Premises and Oracle Cloud

Introduction This article will discuss in high-level the different options available for network connectivity between Oracle GoldenGate (OGG) software running on-premises and GoldenGate Cloud Service (GGCS) instance running on the Oracle Cloud. The following topics are not included in the scope of this article: Installation and Configuration of Oracle GoldenGate (OGG) Software Provisioning of GoldenGate […]

Oracle GoldenGate Best Practices: HP Nonstop Audited Data Replication

Introduction Oracle GoldenGate for HP Nonstop provides capabilities for the manipulation of transactional data and the replication of selected TMF Audited Enscribe, SQL/MP, SQL/MX, and Non-Audited Enscribe data to a variety of applications and platforms. In this article we shall present a series of “best practices” for the configuration and operation of Oracle GoldenGate when […]

Integration of GGCS with EHCS

  Introduction This document will walk you through how to integrate Oracle GoldenGate Cloud Services (GGCS) with Oracle Event Hub Cloud Services (EHCS). The enterprise edition of GGCS supports Oracle GoldenGate Adapter for Big Data which can be used to stream real time data in to Confluent Kafka, running on EHCS. This document covers provisioning […]

GoldenGate Cloud Service (GGCS): How to provision GGCS in Oracle Public Cloud (OPC) via RESTful API

Introduction This document will walk you through how to provision GoldenGate Cloud Service (GGCS) in Oracle Public Cloud (OPC) via RESTful application programming interface (API). For the purpose of this article, it will be using “cURL” as the RESTful client software to demonstrate the RESTful API calls for provisioning GGCS. For checking the progress of […]

GoldenGate Cloud Service (GGCS): Applying Patches to GoldenGate

Introduction This document will walk you through how to patch the Oracle GoldenGate (OGG) in the GoldenGate Cloud Services (GGCS). When there is a patch available for install in to your environment, you will see a message similar to one shown in Figure 1, in your GGCS environment. Before proceeding to apply the patch, stop the processes […]

Oracle GoldenGate: Monitoring via Restful API

Introduction Oracle GoldenGate version 12.1 introduced the ability to monitor on-premises and GoldenGate Cloud Service instances via a Restful API interface. In this article we will show how to enable monitoring and how to obtain information via Restful API for Oracle GoldenGate on-premises instances running version 12.1 or 12.2 and GoldenGate Cloud Service running version 12.2. Main Article Before […]

Oracle Data Integrator Best Practices: Using Check Knowledge Modules on both On-Premises and Cloud Computing

Introduction   This article discusses the best practices for selecting and using Oracle Data Integrator (ODI) Check Knowledge Modules (CKMs) on both on-premises data servers and cloud data services.  In traditional ETL tools, when an ETL data flow is designed, ETL developers must design steps to perform data validation and remove the records that do […]

Oracle GoldenGate: Working With Dates

Introduction By default Oracle GoldenGate handles data for date data types without any user intervention. However, there are times when you may need to manipulate this data based upon end use requirements. Oracle GoldenGate has numerous built-in functions that allows users to test and manipulate data. In this article we shall present the column-conversion functions used to […]

Oracle GoldenGate: Teradata Instantiation

Introduction When working with Teradata customers, we are always asked for recommendations of how to instantiate the target Teradata database. There are numerous ways to accomplish this; including various third-party applications that most customers have in-house. In this article, we will demonstrate a zero down-time data replication implementation from an Oracle 12c Pluggable Database to […]