Connecting to an Oracle autonomous data warehouse

The following procedure should be performed when replicating to an Oracle Autonomous Data Warehouse.

To set up connectivity to Oracle Autonomous Data Warehouse (ADW), you need the Client Credentials (Wallet) ZIP file that you downloaded when you set up your Oracle Autonomous Data Warehouse environment.

To enable Replicate to connect to Oracle Autonomous Data Warehouse:

1. Extract the contents of the Client Credentials ZIP file to a folder of your choice.

   This can be any folder, but for the purpose of this procedure, C:\myapp\adw_credentials will be the Windows folder containing the extracted files while /home/adw_credentials will be the Linux folder containing the extracted files.

2. In the folder containing the extracted files, edit the sqlnet.ora file, replacing ?/network/admin with the path of the folder containing the extracted files:

   Replicate on Windows:

   WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="C:\myapp\adw_credentials")))

   SSL_SERVER_DN_MATCH=yes

   Replicate on Linux:

   WALLET_LOCATION = (SOURCE = (METHOD = file) (METHOD_DATA = (DIRECTORY="/home/adw_credentials")))

   SSL_SERVER_DN_MATCH=yes

3. Create the TNS_ADMIN environment variable and set it to the location of the credentials file.

   Replicate on Windows:

   Set the TNS_ADMIN to C:\myapp\adw_credentials

   Replicate on Linux:

   Run the following commands:

   export TNS_ADMIN=/home/adw_credentials

   export PATH=$TNS_ADMIN:$PATH

4. In the Connection String field in the endpoint's General tab, enter one of the names from the tnsnames.ora file.

For more information on setting up connectivity to Oracle ADW, see:

Connect Autonomous Transaction Processing Using a Client Application