Create Data Source

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

To create the data source:

1. Open the following URL in the browser window: http://<ipaddress>:<administrative console port>/ibm/console (https if SSL is enabled). The Login window is displayed.
2. Log in with the user ID that has admin rights.
3. Expand the Resources option in the LHS menu and click JDBC > Data sources to display the Data sources window.

   Figure 11-13 Data Sources

   
   

   

   
   
4. Select the Scope from the drop-down list. The scope specifies the level at which the resource definition is visible.
5. Click New to display the Create a Data Source window.

   Figure 11-14 Create Data Source

   
   

   

   
   
6. Specify the Data source name and JNDI name for the new "Data Source".
7. The JNDI name and Data source name are case sensitive and ensure that JNDI name is the same as the "Information Domain" name.
8. Click Next to display the Select JDBC provider window.

   Figure 11-15 Select JDBC provider

   
   

   

   
   
9. Select the option Select an Existing JDBC Provider and select the required JDBC provider from the drop-down list. Click Next.

   Figure 11-16 Enter database specific properties

   
   

   

   
   
10. Specify the database connection URL.
    For example: jdbc:oracle:thin:@<DB_SEREVER_IP>:<DB_SERVER_PORT>:<SID>
11. Select Data Store Helper Class Name from the drop-down list and ensure that the Use this data source in container managed persistence (CMP) check box is selected.

    Note:

    For RAC configuration, provide the RAC URL specified during installation.
    Example:

    jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_
    LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.12.13)(port=1521))(ADDRESS=(PRO
    TOCOL=TCP)(HOST=10.11.12.14)(PORT=1521))(LOAD_
    BALANCE=no)(FAILOVER=yes))(CONNECT_DATA=(SERVICE_NAME=pqadb)))

12. Click Next.

    Figure 11-17 Enter Database specific properties

    
    

    

    
    
13. Map the J2C authentication alias, if already created. If not, you can create a new J2C authentication alias by accessing the link given (Global J2C authentication alias) or you can continue with the data source creation by clicking Next and then Finish.

    Figure 11-18 Summary

    
    

    

    
    
    You can also create and map J2C authentication alias after creating the data source.
14. You must create another Data source by following the same procedure with jdbc/FICMASTER as JNDI name pointing to the "configuration schema" of Infrastructure.