Version 26.1.9516

• Add the Oracle Connector
• Authenticate to Oracle
  • Oracle Server
  • Oracle Transport Network Substrate
  • LDAP
• Complete Your Connection
• More Information

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:

1. Open the Connections page of the Sync dashboard.

2. Click Add Connection to open the Select Connectors page.

3. Click the Sources tab and locate the Oracle row.

4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the Oracle connector. For more information about installing new connectors, see Connections.

Authenticate to Oracle

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

On the New Connection page, enter the connection name of your choice.

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 Transport Network Substrate
• 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.

• Wallet (optional) - 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.