# Connecting to an Oracle autonomous data warehouse

Information noteOracle Autonomous Data Warehouse (ADW) 23ai is supported with Oracle Enterprise Edition only.

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](https://help.qlik.com/en-US/replicate/November2025/Content/Replicate/Main/Oracle/OracleDB_Target_DiaBox.htm) 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](https://docs.oracle.com/en/cloud/paas/atp-cloud/atpug/connect-preparing.html#GUID-EFAFA00E-54CC-47C7-8C71-E7868279EF3B)