Configuring JDBC Data Sources (ExpertCTStudio)

Perform the following steps to configure JDBC Data Sources:

1. Create a New JDBC Data Source.
2. Go to mydomain > Services > Data Sources.
   
   
   
   
3. Select New > Generic Data Source.
   
   
   
   

4. Enter the values as shown in the following table:

   Field Name	Values	Comments
   Name	JDBC Data Source-0	Name of the JDBC data source
   JNDI Name	ExpertStudio
   Database Type	Oracle

   
   
    

5. Click Next.

6. Select values for the fields as mentioned in the following table:

   Field Name	Values	Comments
   Database Driver	*Oracle's Driver (Thin) for Service Connections; Versions: Any

   
   
    

7. Click Next. No change required in the given screen.
   
   
   
   
8. Click Next to configure the Connection Properties.

9. Enter the values as mentioned in the following table:

   Field Name	Sample Values	Comments
   Database Name	Database / SID name SIR08875	Database name in which the DB schema for CT is created.
   Host Name	IP Address / Host name 10.10.16.211	The value is the Hostname / IP address of the Database server.
   Port	Port Number 1521	The port number allocated for the Database communication for the IP / host name.
   Database User Name	DB Schema Name CT_EXPERT_STUDIO	Database schema name that is created for CT.
   Password DB	Schema password ****************	Database schema password for CT.
   Confirm Password	DB Schema password ****************	Database schema password for CT.

   
   
    

10. Click Next.
11. Click Test configuration to test the database availability and the connection properties that you have provided.
    
    
    
    
12. Once the test is successful, the following message will appear:
    
    
    
    
13. Click Finish.