Connecting to Database Using SID and Service Name

To connect to the Oracle database using JDBC Thin driver, Oracle provides connection descriptors. Using the connection provider, you can use SID and service names. SID is a unique identifier for an Oracle server, and a service name is an alias for the Oracle server.

The following table describes the steps to connect to the Oracle database using SID and a service name:

For SID For Service Name
Set the value of MDM_DB_USE_SERVICENAME environment variable to false. For information, see Environment Variables. Set the MDM_DB_USE_SERVICENAME environment variable to true.
By default, the value of the Use service name for JDBC connection configuration property is false. Do not change this value to use SID.

  1. Log in to the Configurator.

  2. Set the value of the Use service name for JDBC connection configuration property to true.

  3. Save the changes.

The property enables the connection to the sqlldr utility. The connection is used when importing records using data source and Apache Spark.
By default, the connection URL (supported by the JDBC Thin driver) for SID is <connection-url>jdbc:oracle:thin:@hostname:portnumber:SID</connection-url>

The connection URL is changed to <connection-url>jdbc:oracle:thin:@//hostname:portnumber/service_name</connection-url>.

You must specify this updated connection URL when creating data sources during the application server configuration.

To use the sqlldr utility and the Oracle client, set false for the Enable JDBC thin connection (com.tibco.cim.enable.jdbc.thin.connection) property, and to use thin drivers without the Oracle client, set the property to true.