You can use the DataHub plug-in for Oracle GoldenGate (OGG) 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.
1. Overview
You can use the DataHub plug-in for OGG 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 / varchar2 | STRING | |
number | BIGINT / DOUBLE / 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 / BINARY_DOUBLE | DOUBLE / DECIMAL | |
FLOAT | DOUBLE / DECIMAL | |
date / timestamp | TIMESTAMP / 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 Application Adapters and OGG for Big Data. If the version that you want to download is not provided, visit Oracle GoldenGate Downloads or Oracle Software Delivery Cloud to download the version.
datahub-ogg-plugin | Source database | Destination database | Supported Oracle database version |
OGG 12.1.x.x (recommend version: 12.1.2.1) | OGG Application Adapters 12.1.2.1 | Oracle Database 11g | |
OGG 12.2.x.x (recommended version: 12.2.0.2) | OGG Application Adapters 12.2.0.1 | Oracle Database 11g | |
OGG 12.2.x.x (recommended version: 12.2.0.2) | OGG Application Adapters 12.2.0.1 | Oracle Database 11g | |
OGG 12.2.x.x (recommended version: 12.2.0.2) | OGG Application Adapters 12.2.0.1 | Oracle Database 11g | |
OGG 12.2.x.x (recommended version: 12.2.0.2) | OGG Application Adapters 12.2.0.1 | Oracle Database 11g | |
OGG 12.3.x.x (recommended version: 12.3.2.1) | OGG for Big Data 12.3.2.1 | Oracle Database 11g and 12c | |
OGG 19.1.x.x (recommended version: 19.1.0.0) | OGG for Big Data 19.1.0.0 | Oracle Database 19c and earlier |