- Create a New JDBC Data Source.
- Go to mydomain > Services > Data Sources.
- Select New > Generic Data Source.
- Enter the values as shown in the following table:
Field Name
Values
Comments
Name
JDBC Data Source-1
Name of the CT implementation data source
JNDI Name
ExpertStudioTarget
Database Type
Oracle
- Click Next.
- 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 |
|
- Click Next. No change required in the given screen.
- Click Next to configure the Connection Properties.
- Enter the values as mentioned in the following table:
Field Name |
Value to be Selected (Sample values shown) |
Comments |
---|---|---|
Database Name |
Database / SID name SIR08875 |
Database name in which the DB schema for CT Implementation 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 |
The port number allocated for the Database communication for the IP / host name. |
Database User Name |
DB Schema Name CT_MODEL_HOUSE |
Database schema name that is created for CT Implementation. |
Password DB |
Schema password **************** |
Database schema password for CT Implementation. |
Confirm Password |
DB Schema password **************** |
Database schema password for CT Implementation. |
- Click Next.
- Click Test configuration to test the database availability and the connection properties that you have provided.
- Once the test is successful, the following message will appear:
- Click Next to select the Target server.
- Select AdminServer.
- After verifying the changes, click Finish.