> ## 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

export const CommonDatasourceMoreInformation = ({datasource = "the data source", advancedurl = "", siteName = "CData Sync", driverVersion = ""}) => {
  return <>
      <p>
        For more information about interactions between {siteName} and {datasource}, see{' '}
        <a href={`https://cdn.cdata.com/help/${advancedurl}${driverVersion}/synch/default.htm`}>
          {datasource} Connector for {siteName}
        </a>.
      </p>
    </>;
};

export const CommonDatasourceAddConnector = ({datasource = "the data source", title = "the connector", destination = false, siteNameShort = "Sync"}) => {
  return <>
      <p>
        To enable {siteNameShort} to use data from {datasource}, you first must add the
        connector, as follows:
      </p>
      <ol>
        <li>Open the <strong>Connections</strong> page of the {siteNameShort} dashboard.</li>
        <li>Click <strong>Add Connection</strong> to open the <strong>Select Connectors</strong> page.</li>
        <li>
          Click the <strong>{destination ? "Destinations" : "Sources"}</strong> tab and locate
          the <strong>{title}</strong> row.
        </li>
        <li>
          Click the <strong>Configure Connection</strong> icon at the end of that row to open
          the <strong>New Connection</strong> page. This action opens the{' '}
          <strong>Add Connection</strong> dialog box.
          <br />
          <strong>Note:</strong> If the <strong>Configure Connection</strong> icon is not
          available, click the <strong>Download Connector</strong> icon to install
          the {title} connector.
        </li>
        <li>Enter a name for your connection in the <strong>Add Connection</strong> dialog box.</li>
        <li>Click <strong>Add</strong> to open the <strong>Settings</strong> tab for your connector.</li>
      </ol>
      <p>
        For more information about installing new connectors, see{' '}
        <a href="../connections">Connections</a>.
      </p>
    </>;
};

export const CommonDatasourceIntroSource = ({datasource = "the data source", siteName = "CData Sync"}) => {
  return <p>
      You can use the {datasource} connector from the {siteName} application to capture data
      from {datasource} and move it to any supported destination. To do so, you need to add
      the connector, authenticate to the connector, and complete your connection.
    </p>;
};

export const driverVersion = "M";

export const siteNameShort = "Sync";

export const siteName = "CData Sync";

export const datasource = "Oracle";
export const pageTitle = "Oracle";
export const advancedurl = "SO";

<CommonDatasourceIntroSource datasource={datasource} siteName={siteName} />

## Add the Oracle Connector

<CommonDatasourceAddConnector datasource={datasource} title={pageTitle} destination={false} siteNameShort={siteNameShort} />

## Authenticate to Oracle

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

{siteName} supports authenticating to {datasource} 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.</Note>

* **User:** Enter the username that you use to authenticate to your {datasource} account.

* **Password:** Enter the password that you use to authenticate to your {datasource} 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 {datasource} 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 {datasource} account.
* **Password:** Enter the password that you use to authenticate to your {datasource} 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 {datasource} account.
* **Password:** Enter the password that you use to authenticate to your {datasource} 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

<CommonDatasourceMoreInformation datasource={datasource} advancedurl={advancedurl} siteName={siteName} driverVersion={driverVersion} />