Friday, June 29, 2012

Create JNDI for a new DB in IBPM

In this post, I would put steps on how to create a JNDI for a new DB to be connected from IBPM (aka lombardi). Below are the steps to create a new JNDI:
  1. In a web browser, bring up the WebSphere Administrative Console. For example, https://localhost:9043/admin. The port number may be different in your environment. You can look in the <WLE_HOME>/AppServer/profiles/Lombardi/logs/ProcessCenter01 Service.log file to determine the port number.
  2. Log in as tw_user. The password is tw_user. Alternatively, if you don’t see admin privilege once you logged in try login as admin (password: admin) as shown in  Figure-1.
  3. Figure-1
          In the navigation pane go to Resources > JDBC > Data sources.
  4. In All scopes, you see five data sources that were created during product installation. One is the default "Datasource" and the other four are related to Lombardi Teamworks. 
  5. You will create a new data source that points to the sample database:
a.       Change the Scope to Cell=LombardiCell01. 
b.   Click New. 
c.    Enter a data source name. Let it be KYC Data Base Data Source. 
d.    Enter a JNDI name, for example, jdbc/sampleKYC (Figure 2) and click Next.

6. You may choose to create a new JDBC provider. Since one already exists for DB2, we can select  an existing JDBC provider.
7. Click Select an existing JDBC Provider. From the drop down list, select TeamWorks Process Server DB2 JDBC Driver as shown in Figure 3 and click Next
1     8.  Perform below steps in the next screeen.
    1. For the driver type, choose 4.
    2. Enter the database name as KYCDB. (name of the database that you have created.)
    3. Enter the database server name as VALUED-625CDF07. (Name of the host where DB is installed)
    4. If the port number is not filled in, enter the database port number as shown in Figure 4. The default port number for DB2 is 50000.
    5. Click Next.

1   9. Choose the processdblogon alias (Figure 5) for all, except the mapping-configuration alias. And  Click Next.

           Note: Typically, you create a J2C authentication alias. Since you are simply using a different  database table in the same DB2 instance, you can use the existing J2C aliases.

1        10. On the Summary screen, double-check the values and click Finish, as shown in below Figure.
         11.   Save to the master configuration and restart the server.
         12.   Select the newly created data source and click the Test connection button.
a.       Make sure the connection is successful. If there are errors, fix them before proceeding. 
b.   You may now exit from the WebSphere Administrative Console.

  Once the the JNDI  (jdbc/sampleKYC) is created, you can use this datasource in your sql connectors.

No comments:

Post a Comment