> ## Documentation Index
> Fetch the complete documentation index at: https://docs.sync.cdata.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Oracle

You can use the Oracle connector from the CData Sync application to capture data
from Oracle and move it to any supported destination. To do so, you need to add
the connector, authenticate to the connector, and complete your connection.

## Add the Oracle Connector

To enable Sync to use data from Oracle, you first must add the
connector, as follows:

<ol>
  <li>Open the **Connections** page of the Sync dashboard.</li>
  <li>Click **Add Connection** to open the **Select Connectors** page.</li>
  <li>Click the **Sources** tab and locate
  the **Oracle** row.</li>

  <li>
    Click the **Configure Connection** icon at the end of that row to open
    the **New Connection** page. This action opens the
    **Add Connection** dialog.

    **Note:** If the **Configure Connection** icon is not
    available, click the **Download Connector** icon to install
    the Oracle connector.
  </li>

  <li>Enter a name for your connection in the **Add Connection** dialog.</li>
  <li>Click **Add** to open the **Settings** tab for your connector.</li>
</ol>

For more information about installing new connectors, see
[Connections](https://docs.sync.cdata.com/26.4/en/connections/connections.md).

## Authenticate to Oracle

After you add the connector, you need to set the required properties.

CData Sync supports authenticating to Oracle via various connection types. Select your connection type below to proceed to the relevant section that contains the authentication details.

* [**Server**](#oracle-server)
* [**Oracle Transport Network Substrate**](#oracle-transport-network-substrate)
* [**LDAP**](#ldap)

### Oracle Server

To authenticate via the Oracle server, specify the following properties:

* **Connection Type:** Select **Server**.

* **Server:** Enter the host name or IP address of the server that hosts the Oracle database.

* **Service Name:** Enter the service name of the Oracle database. You can obtain this value by submitting the following query from the Oracle SQL\*PLUS command line:

  `SELECT * FROM global_name;`

  > [!NOTE]
  >
  > The result of this query returns the global database name, which might not always align with the service name that is defined in the Oracle listener. If there is any uncertainty, verify the result with your DBA or review the tnsnames.ora file to confirm the correct service name.

* **User:** Enter the username that you use to authenticate to your Oracle account.

* **Password:** Enter the password that you use to authenticate to your Oracle account.

* **Port:** Enter the port that you want to use to connect to the server that hosts the Oracle database.

* (Optional) **Wallet:** Enter the location of the client's Oracle Wallet.

### Oracle Transport Network Substrate

To authenticate via Oracle Transport Network Substrate (TNS), specify the following properties:

* **Connection Type:** Select **OracleTNS**.
* **User:** Enter the username that you use to authenticate to your Oracle account.
* **Password:** Enter the password that you use to authenticate to your Oracle account.
* **Data Source:** Enter the Oracle Net Services Name, the Connect Descriptor (also known as the TNS Connect String), or a connection name that identifies the database to which you want to connect. You should be able to find these values in your tnsnames.ora file.

  **Example:** `DataSource='(DESCRIPTION=(ADDRESS=(ProtocolAddressInformation))(CONNECT_DATA= (SERVICE_NAME=ServiceName)))'`

### LDAP

To authenticate via the LDAP server, specify the following properties:

* **Connection Type:** Select **LDAP**.
* **User:** Enter the username that you use to authenticate to your Oracle account.
* **Password:** Enter the password that you use to authenticate to your Oracle account.
* **LDAP Uri:** Enter the LDAP URI that you use to connect to the LDAP server.

  **Example:** `LDAPUri=ldap://myldap.com:389/SERVICE_EXMPL,cn=OracleContext,dc=example,dc=com; User=OracleUser; Password=OracleUserPassword;`

## Complete Your Connection

To complete your connection:

1. Define advanced connection settings on the **Advanced** tab. (In most cases, though, you should not need these settings.)
2. Click **Create & Test** to create your connection.

## More Information

For more information about interactions between CData Sync and Oracle, see
[Oracle Connector for CData Sync](https://cdn.cdata.com/help/SON/synch/default.htm).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.