Configuring and running the EDB DMS Reader v1.2

Configure and run the DMS Reader to perform a data migration.

Prerequisites

  1. Ensure the machine from where you are running the Reader has Java/OpenJDK 17 or later installed.

  2. Install the EDB DMS Reader.

  3. Open the EDB DMS Reader located in /opt/cdcreader/run-cdcreader.sh and ensure you have write permissions.

Configuring the EDB DMS Reader for migrations from Oracle

Set the variables according to your environment and uncomment the edited lines. See parameters for further guidance. The script is reproduced below.

#!/bin/bash -e
# run_cdcreader.sh
#
# This script provides a convenient place to specify
# environment variables used to configure the
# EDB Data Migration Service Reader.
#
# After env exports, `java` is called to start the
# software.

##########################################
# DMS Reader General Configuration       #
##########################################

# This ID is used to identify DMS Reader
# and is specified by the user.
export DBCONFIG_ID=<source_name_of_choice>

# This is the DMS backend service used by the Reader
# Consult your system administrators
export RW_SERVICE_HOST=<https://transporter-rw-service.yourdomain.hcp>

# You need to create migration credentials in EDB Postgres AI platform
# and set these fields with the path of the credential files
export TLS_PRIVATE_KEY_PATH=$HOME/credentials/client-key.pem
export TLS_CERTIFICATE_PATH=$HOME/credentials/client-cert.pem
export TLS_CA_PATH=$HOME/credentials/int.crt
export APICURIOREQUEST_CLIENT_KEYSTORE_LOCATION=$HOME/credentials/client.keystore.p12
export APICURIOREQUEST_TRUSTSTORE_LOCATION=$HOME/credentials/int.truststore.p12
export KAFKASECURITY_CLIENT_KEYSTORE_LOCATION=$HOME/credentials/client.keystore.p12
export KAFKASECURITY_TRUSTSTORE_LOCATION=$HOME/credentials/int.truststore.p12

##########################################
# DMS Reader Source DB Configuration     #
##########################################

# A sample configuration to create a single postgres database connection:
export DBCONFIG_DATABASES_0__TYPE=ORACLE
export DBCONFIG_DATABASES_0__HOSTNAME=<host>
export DBCONFIG_DATABASES_0__PORT=<1521>
# The CATALOG is the database name
export DBCONFIG_DATABASES_0__CATALOG=<source>
export DBCONFIG_DATABASES_0__USERNAME=<SYS>
# The password env can be set without specifying it here
# but the env structure looks like this
export DBCONFIG_DATABASES_0__PASSWORD=<password>

# You can increase the index to configure more than
# one database for the DMS Reader
#export DBCONFIG_DATABASES_1__TYPE=ORACLE
#export DBCONFIG_DATABASES_1__HOSTNAME=localhost
#export DBCONFIG_DATABASES_1__PORT=1521
# The CATALOG is the database name
#export DBCONFIG_DATABASES_1__CATALOG=ORCLCDB/ORCLPDB1
#export DBCONFIG_DATABASES_1__USERNAME=oracle
# The password env can be set without specifying it here
# but the env structure looks like this
#export DBCONFIG_DATABASES_1__PASSWORD=password

##########################################
# Optional Parameters Below              #
##########################################

# FIPS mode can be enabled by setting the FIPS_MODE env variable to true
#export FIPS_MODE=true

# Configure logging
# Generic loglevel
#export QUARKUS_LOG_LEVEL=DEBUG
# Loglevel for a single package
#export QUARKUS_LOG_CATEGORY__COM_ENTERPRISEDB__LEVEL=DEBUG

cd "$(dirname "$0")"

java -jar quarkus-run.jar

Running the EDB DMS Reader

Start the migration:

cd /opt/cdcreader
./run-cdcreader.sh