Skip to main content
Version: 2.8

8 Examples​

8.1 Connect to Oracle​

Example of variables in configs/anon/some_oracle_source.evl which need to be set to connect to Oracle DB:

export SOURCE_DB="some_schema"
export TARGET_DB="some_schema"
export TARGET_TABLE_SUFFIX="_anon"

export ORAUSER="some_user"
export ORAPASS="$(cat $HOME/.orapass)"
export ORACONN="(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)
                                                    (HOST=12.34.56.78)
                                                    (PORT=1521)))
                             (CONNECT_DATA=(SERVER=DEDICATED)
                                           (SERVICE_NAME=abcd)))"

export TARGET_CONN="12.34.56.79:1521/abcd"