Installation steps

Gluesync NoSQL to SQL for Oracle database

Prerequisites

To have Gluesync working on your Oracle instance you will need to have:

valid user credentials with permission to read, and write to the target tables and respective database

Basic configuration example

This video tutorial will guide you through the basic configuration steps for setting up Gluesync for Oracle database and Couchbase.

This module can be customized by using a configuration file, in JSON format. The file name to use must be specified as a parameter when launching the app, with the -f or --file tokens. The file should be composed by the union of the common configuration files (see here Installation steps) and source/destination specific configuration:

{
  ...
  "oracle": {
    "cdbName": "oracle-container-db-name",
    "pdbName": "oracle-pluggable-db-name",
    "connectionType": "SID"
  }
}

Oracle-specific configurations are listed under the oracle property.

cdbName: name of the container database of your scope;
pdbName: name of the pluggable database that contains the data you need to replicate.
connectionType (optional): connection type used to connect to Oracle. Available types are: SID or SERVICE_NAME. Defaults to SID.
tableKeys: is the object that represents the key-value pair list of tables and its columns that compose your clustered index, the format is SCHEMANAME.TABLENAME.

Looking for data modeling features or other options?

For more detailed configuration options, including the ability to perform data modeling, please have a look at the dedicated Data modeling section when sourcing from an RDBMS.