Steps:

1. Create a new driver and select Other Driver.

2. In the JAR List tab, add the appropriate driver JAR file.

3. Go to the Properties tab and specify the connection URL in the format:

jdbc:oracle:thin:@//<server_name>:1521/<service_name>

Here, <service_name> refers to the Oracle service name.

4. Set the driver class as:

oracle.jdbc.OracleDriver

5.  In the Connection Details dialog, enter the correct server name and service name.

6. Click Test Connection to validate the setup.

ALL MDM STUDIO VERSION

This article describes the steps to create a database connection in MDM Studio using the Oracle service_name.