All Products
Search
Document Center

OGG for Oracle

Last Updated: Aug 06, 2021

You can use the DataHub plug-in to collect Oracle data based on Oracle GoldenGate (OGG) Application Adapters or OGG for Big Data. The difference between the two modes is that different processes are used in the destination database.

1. Overview

You can use the DataHub plug-in to collect Oracle data based on OGG Application Adapters or OGG for Big Data. The difference between the two modes is that different processes are used in the destination database.

If you write data to DataHub based on OGG Application Adapters, the Extract process is used in the destination database, as shown in the following figure.

If you write data to DataHub based on OGG for Big Data, the Replicat process is used in the destination database, as shown in the following figure.

Main differences between the two modes:

1.Supported Oracle database versions: If you use OGG Application Adapters, you can write data only from Oracle Database 11g to DataHub. If you use OGG for Big Data, you can write data from Oracle Database 19c and earlier to DataHub. 2.Update frequency: The latest version of OGG Application Adapters is 12.2. It has not been updated for a long time and has some known issues that have not been resolved. OGG for Big Data has been updated almost synchronously with Oracle. The DataHub plug-in for OGG for Big Data will be continuously updated, but the DataHub plug-in for OGG Application Adapters is no longer updated.

We recommend that you write data to DataHub based on OGG for Big Data.

2. Mappings between data types in Oracle and DataHub

The unit of field values of the TIMESTAMP type in DataHub is microseconds. When you map field values of the DATE or TIMESTAMP type from Oracle to DataHub, the values are converted into timestamps in microseconds.

Oracle

DataHub

Description

CHAR

STRING

VARCHAR and VARCHAR2

STRING

NUMBER

BIGINT, DOUBLE, and DECIMAL

An integer can be converted into a value of the BIGINT type. A floating-point number can be converted into a value of the DOUBLE or DECIMAL type based on the required accuracy.

INTEGER

BIGINT

BINARY_FLOAT and BINARY_DOUBLE

DOUBLE and DECIMAL

FLOAT

DOUBLE and DECIMAL

DATE and TIMESTAMP

TIMESTAMP and STRING

Field values of the TIMESTAMP type in DataHub are automatically converted into timestamps in microseconds.

RAW

STRING

Field values of the RAW type are automatically encoded in Base64 and then written to DataHub.

The preceding table describes the mappings between common data types in Oracle and DataHub. For more information about the data types supported by Oracle, see Details of Support for Oracle Data Types.

3. Version description and download

This section provides only some versions of OGG and OGG Application Adapters. If the version that you want to download is not provided, visit Download OGG or Oracle Software Delivery Cloud to download the version.

datahub-ogg-plugin

Source database

Destination database

Supported Oracle database version

2.0.2

OGG 12.1.x.x (Recommend version: 12.1.2.1)

OGG Application Adapters 12.1.2.1

Oracle Database 11g

2.0.3

OGG 12.2.x.x (Recommended version: 12.2.0.2)

OGG Application Adapters 12.2.0.1

Oracle Database 11g

2.0.4

OGG 12.2.x.x (Recommended version: 12.2.0.2)

OGG Application Adapters 12.2.0.1

Oracle Database 11g

2.0.5

OGG 12.2.x.x (Recommended version: 12.2.0.2)

OGG Application Adapters 12.2.0.1

Oracle Database 11g

2.0.6

OGG 12.2.x.x (Recommended version: 12.2.0.2)

OGG Application Adapters 12.2.0.1

Oracle Database 11g

2.0.7

OGG 12.3.x.x (Recommended version: 12.3.2.1)

OGG for Big Data 12.3.2.1

Oracle Database 11g and 12c

2.0.8

OGG 19.1.x.x (Recommended version: 19.1.0.0)

OGG for Big Data 19.1.0.0

Oracle Database 19c and earlier