This topic provides systematic instructions for Data source creation for non XA.

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

   Figure 6-1 Summary of JDBC Data Sources

   
   

   
   Description of "Figure 6-1 Summary of JDBC Data Sources"

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

   Figure 6-2 Create a New JDBC Data Source- JDBC Data Source Properties

   
   

   
   Description of "Figure 6-2 Create a New JDBC Data Source- JDBC Data Source Properties"

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

   Figure 6-3 Create a New JDBC Data Source- JDBC Data Source Properties

   
   

   
   Description of "Figure 6-3 Create a New JDBC Data Source- JDBC Data Source Properties "

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

   Figure 6-4 Create a New JDBC Data Source- Transaction Options

   
   

   
   Description of "Figure 6-4 Create a New JDBC Data Source- Transaction Options"

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

   Figure 6-5 Create a New JDBC Data Source- Connection Properties

   
   

   
   Description of "Figure 6-5 Create a New JDBC Data Source- Connection Properties"

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

   Figure 6-6 Create a New JDBC Data Source- Test Database Connection

   
   

   
   Description of "Figure 6-6 Create a New JDBC Data Source- Test Database Connection"

   
   
8. Replace the JDBC URL field in the below format and click 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 Test Configuration.
   The connection test should be successful.
   The Create a New JDBC Data Source- Targets screen displays.

   Figure 6-7 Create a New JDBC Data Source- Targets

   
   

   
   Description of "Figure 6-7 Create a New JDBC Data Source- Targets"

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