2 Introduction

This guide describes how to install and configure Oracle GoldenGate Microservices for an Oracle Utilities on-premises source application. Oracle GoldenGate supports change data capture (CDC) and transfers source application data to Oracle Utilities Data Intelligence (OUDI) for processing, analysis, and visualization.

For ongoing data synchronization, OUDI uses Oracle GoldenGate to transfer incremental data changes from the source application database to the target Autonomous Database. Oracle GoldenGate captures committed database transactions, writes the changes to trail files, and transfers the trail files securely to the target environment. To support this process, install and configure Oracle GoldenGate Microservices and establish connectivity between the source and target environments.

In addition to incremental data synchronization, OUDI requires an initial export of source application data. The initial export process generates dump files, log files, and manifest files from the source application database. After the export completes, upload the export artifacts to the customer object storage bucket for processing in the next stage.

The following sections describe the prerequisite tasks, Oracle GoldenGate configuration tasks, initial data export procedures, and performance recommendations for integrating a source application with OUDI.

Assumptions

The following assumptions apply in this document:

  • The utility has an Oracle Database installation that supports a source application, such as Customer to Meter (C2M), Meter Data Management (MDM), or Work and Asset Management (WAM).

  • The utility has an Oracle Cloud Infrastructure (OCI) Platform as a Service (PaaS) environment or OCI Free Tier tenancy and network connectivity to the server or virtual machine that hosts Oracle GoldenGate Microservices.

  • Oracle GoldenGate can connect to the source application database.