Configuring and running the EDB DMS Reader v1.2
Configure and run the DMS Reader to perform a data migration.
Prerequisites
Ensure the machine from where you are running the Reader has Java/OpenJDK 17 or later installed.
Open the EDB DMS Reader located in
/opt/cdcreader/run-cdcreader.shand 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