Configuring vba_preview

Config a source reader

Get credentials

  • Create and download a migration credentials from the postgres AI platform Migrate -> Credentials section
  • un-zip the credential and copy the whole folder to the host where the reader is installed

Configure the reader

Set the following environment variables in /opt/cdcreader/run-cdcreader.sh with the right values:

### set the following environment variables:

##########################################
# Transporter Cloud Configuration        #
##########################################

# This ID is used to identify the cdcreader.
#export DBZ_ID="my_reader_id"
#export RW_SERVICE_HOST=https://transporter-rw-service.biganimal.com
#export TLS_PRIVATE_KEY_PATH=$MY_CREDENTIALS_PATH/client-key.pem
#export TLS_CERTIFICATE_PATH=$MY_CREDENTIALS_PATH/client-cert.pem
#export TLS_CA_PATH=$MY_CREDENTIALS_PATH/int.crt
#export APICURIOREQUEST_CLIENT_KEYSTORE_LOCATION=$MY_CREDENTIALS_PATH/client.keystore.p12
#export APICURIOREQUEST_TRUSTSTORE_LOCATION=$MY_CREDENTIALS_PATH/int.truststore.p12
#export KAFKASECURITY_CLIENT_KEYSTORE_LOCATION=$MY_CREDENTIALS_PATH/client.keystore.p12
#export KAFKASECURITY_TRUSTSTORE_LOCATION=$MY_CREDENTIALS_PATH/int.truststore.p12

##########################################
# Transporter Source DB Configuration    #
##########################################

# A sample configuration to create a single database connection:
#export DBZ_DATABASES_0__TYPE=POSTGRES
#export DBZ_DATABASES_0__HOSTNAME=my_db_hostname
#export DBZ_DATABASES_0__PORT=my_db_port
#export DBZ_DATABASES_0__CATALOG=my_db_catalog
#export DBZ_DATABASES_0__USERNAME=my_db_username
#export DBZ_DATABASES_0__PASSWORD=my_db_password

Running the reader

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