Skip to main content

​
Add the Oracle Connector

​
Authenticate to Oracle

After you add the connector, you need to set the required properties. supports authenticating to via various connection types. Select your connection type below to proceed to the relevant section that contains the authentication details.

​
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;
    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 account.
  • Password: Enter the password that you use to authenticate to your 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 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 account.
  • Password: Enter the password that you use to authenticate to your 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 account.
  • Password: Enter the password that you use to authenticate to your 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