Create Data Source

Create a data source. This process is applicable to both config and atomic data source creation.

To create a data source:

1. Open the following URL in the browser window:
   http://<ipaddress>:<administrative console port>/console. (https, if SSL is enabled). The Welcome window is displayed.
2. Log in with the Administrator Username and Password.

   Figure 11-44 Welcome

   
   

   

   
   
3. From the LHS menu (Domain Structure), click Services > Data Sources to display the Summary of JDBC Data Sources window.

   Figure 11-45 Summary of JDBC Data Sources

   
   

   

   
   
4. Click New and select Generic Data Source to display the Create a New JDBC Data Source window.

   Figure 11-46 Create a New JDBC Data Source

   
   

   

   
   
   You can also select GridLink Data Source or Multi Data Source while creating a Data Source. For more information, see Create GridLink Data Source or Configure Multi Data Sources.
5. In the Create a New JDBC Data Source window, enter JDBC data source Name, JNDI Name, and select the Database Type from the drop-down list, and then click Next to access the JDBC Data Source Properties window.

   Note:

   Ensure the following:

   1. The JNDI Name field must be in the format jdbc/informationdomain
   2. The same steps must be followed to create a mandatory data source pointing to the "configuration schema" of infrastructure with jdbc/FICMASTER as JNDI name.
   3. JNDI Name is the same as mentioned in the web.xml file of OFSAAI Application.
   4. Required Database Type and Database Driver must be selected.

   Note:

   Data sources must be created for atomic and atomiccnf schemas following the same steps.
6. In the JDBC Data Source Properties window, select the Database Driver from the drop-down list. You must select the Database Driver depending on database setup, that is, with or without RAC. Click Next to access Transaction Options.

   Figure 11-47 JDBC Data Source Properties

   
   

   

   
   
7. Select the Supports Global Transactions check box and the One-Phase Commit option.

   Figure 11-48 Transaction Options

   
   

   

   
   
8. Click Next to access the Connection Properties window. Enter the required details such as the Database Name, Host Name, Port, Oracle User Name, Password, and Confirm Password.

   Figure 11-49 Database Name

   
   

   

   
   
9. Click Next to display the Test Database Connection window. Verify the details and click Test Configuration and test the configuration settings.

   Figure 11-50 Database Details

   
   

   

   
   
   A confirmation message is displayed stating Connection test succeeded.
10. After testing the configuration, click Next to access the Select Targets window, and then select the target(s) to deploy the new JDBC Data Source.

    Figure 11-51 Select Targets

    
    

    

    
    
11. Select the AdminServer option and click Finish. The created Data Source is displayed in the list of Data Sources.

    Note:

    • User ID is the Oracle user ID that is created for the respective Information Domain.
    • User ID specified for a data source with FICMASTER as JNDI name must be the Oracle user ID created for the configuration schema.