Creating Data Source for CES Database

How To Create Data Source for CES Database

You need to create the data source for CES database as a part of the post installation tasks.
This task explains how to create data source for CES:
  1. Log on to the WebSphere Administrative console using the default url <http://localhost:9160/admin>, unless the port number has changed. If the port number has changed, contact your WebSphere Administrator for log on details.

  2. Enter the User ID, and then click Log in.

    The Administration Console page appears.

  3. In the navigation pad, select Resources > JDBC Providers.

    The JDBC Providers page appears.

  4. From the drop-down list, select the CES Server.

  5. After you have selected the CES server from the list displayed, click New.

  6. In the Create New JDBC Provider Wizard, select the Database type, the Provider type, and the Implementation type from the drop-down lists and click Next.

    For Oracle:

    From the Database type list, select Oracle
    From the Provider type list, select Oracle JDBC Driver
    From the Implementation type list, select Connection pool data source.

    For DB2:

    From the Database type list, select DB2
    From the Provider type list, select DB2 Universal JDBC Driver Provider
    From the Implementation type list, select Connection pool data source.
     

  7. If the WebSphere variable set for the JDBC driver is not correct, the administrator can enter the valid JDBC driver path and click Next.

  8. In the Summary panel, make sure all values are correct and then click Finish.

  9. The following message appears at the top of the WAS Console, prompting you to save your changes. Click Save.

  10. Click the newly created JDBC Provider link from the list. In this example the newly create JDBC provider is DB2 Universal JDBC Driver Provider.

  11. In the JDBC Provider panel, click Data sources in the Additional Properties section. The Data Sources page appears.
     

     

  12. Click New to create a new data source for the JDBC provider.

    The Data Source Creation Wizard appears.

  13. Enter the Data source name and the JNDI name. For example:

    In the
    Data source name field, enter SRMDB
    In the
    JNDI Name field, enter jdbc/SRMDB

    Click Next

    For  DB2, you see the following:



    For Oracle, you see the following:

  14. For DB2, enter the Database name, Driver type, Server name, and Port number.

    In the Database name field, enter the database name.
    In the
    Server name field, enter the server name where the database is available.
    In the Port number field, enter the TCP IP listener port number.
    Note: Contact your database administrator to obtain the TCP IP listener port number.

    For Oracle, in the URL field enter the database details. For example, jdbc:oracle:thin:@localhost:1521:SRMDB.
    For the exact values of the database name, and port number, contact your database administrator.

    Click Next. The Summary page appears.

  15. Make sure the information on the Summary page is correct. If it is, click Finish. The Data source is created. Click Save .