7.1 Data source creation: non XA

This topic provides systematic instructions for Data source creation.

1. Navigate to FCUBSDomain left panel.
2. Click on the Services drop-down option and then click on the Data Sources.
   Summary of JDBC Data Sources screen displays.

   Figure 7-1 Summary of JDBC Data Sources- TBD Redwood

   
   

   
   Description of "Figure 7-1 Summary of JDBC Data Sources- TBD Redwood"

   
   
3. Navigate to the New drop down button and select Generic Data Source option.
   Create a New JDBC Data Source- JDBC Data Source Properties screen displays.

   Figure 7-2 Create a New JDBC Data Source- JDBC Data Source Properties (TBD Redwood)

   
   

   
   Description of "Figure 7-2 Create a New JDBC Data Source- JDBC Data Source Properties (TBD Redwood)"

   
   
4. Enter the Name and JNDI Name fields and click on the Next button.
   Create a New JDBC Data Source- JDBC Data Source Properties screen displays.

   Figure 7-3 Create a New JDBC Data Source- JDBC Data Source Properties (TBD Redwood)

   
   

   
   Description of "Figure 7-3 Create a New JDBC Data Source- JDBC Data Source Properties (TBD Redwood)"

   
   
5. Select the Database Driver as Oracle’s Driver (Thin) for Instance connections: Versions: Any and click on the Next button.
   Create a New JDBC Data Source- Transaction Options screen displays.

   Figure 7-4 Create a New JDBC Data Source- Transaction Options (TBD Redwood)

   
   

   
   Description of "Figure 7-4 Create a New JDBC Data Source- Transaction Options (TBD Redwood)"

   
   
6. Uncheck the Supports Global Transactions option and click on the Next button.
   Create a New JDBC Data Source- Connection Properties screen displays.

   Figure 7-5 Create a New JDBC Data Source- Connection Properties (TBD Redwood)

   
   

   
   Description of "Figure 7-5 Create a New JDBC Data Source- Connection Properties (TBD Redwood)"

   
   
7. Enter the Database Name, Host Name, Port, Database User Name, Password, and Confirm Password fields and then click on the Next button.
   Create a New JDBC Data Source- Test Database Connection screen displays.

   Figure 7-6 Create a New JDBC Data Source- Test Database Connection (TBD Redwood)

   
   

   
   Description of "Figure 7-6 Create a New JDBC Data Source- Test Database Connection (TBD Redwood)"

   
   
8. Replace the JDBC URL field in the below format and click on the Next button.
   Default URL: jdbc:oracle:thin:@<IP_Adress>:<Port>:<INSTANCE_NAME>.
   Change the default URL to: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxx.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=fcubs))
   Where, Scan IP = xxxxxx.com, Service Name = fcubs, Port = 1521
   The user should make the necessary changes to the URL.
9. Click on the Test Configuration.
   The connection test should be successful.
   Create a New JDBC Data Source- Targets screen displays.

   Figure 7-7 Create a New JDBC Data Source- Targets (TBD Redwood)

   
   

   
   Description of "Figure 7-7 Create a New JDBC Data Source- Targets (TBD Redwood)"

   
   
10. Select Target as FCUBSCluster and click on the Finish button.