Creating and configuring the data source

Once you have created the FFDB database, you must configure WebSphere® Integration developer to recognize it as the data source.

  1. Open WebSphere Integration Developer. The Business Integration perspective will open by default.
  2. On the bottom right corner of the Business Integration perspective, click on the Server tab to bring it to the front.
  3. Right-click your server instance and select Start.
  4. Confirm that the server is active and ready for transaction requests. When it is ready, the Console window will say Server <server profile> is open for business.
  5. Open the test server's administrative console window by right-clicking the server profile on the Server tab and selecting Run Administrative Console. The port number for the administrative console may differ based on your setup. If your port number is different from the default, use your specific port number.
  6. In the user ID field, enter the default administrative user ID admin and click Log in.
  7. Create a JDBC data source in WebSphere Process Server. This tells WebSphere Process Server that the data is from FFDB, the database that you created.
    1. In the left pane of the administrative console, select Resources > JDBC Providers. Confirm that Node: widNode is selected in the JDBC providers pane.
    2. Select the check box for Cloudscape JDBC Provider (XA) and click New.
      Figure 1. New JDBC providers pane
      This image is described in the surrounding text.
    3. In the Configuration window, select Cloudscape as the database type, Cloudscape JDBC Provider as the provider type, and XA data source as the implementation type. Click Next.
      Figure 2. JDBC providers configuration pane
      This image is described in the surrounding text.
    4. Click OK in the General Properties window.
    5. Click Cloudscape JDBC Provider (XA), then click Data Sources from the right pane of the window.
      Figure 3. Data sources selection window
      This image is described in the surrounding text.
    6. Select New and then type DB2JNDI in the JNDI name field.
    7. Scroll down to the Database name field and type FFDB.
    8. Click OK.
  8. Click Save to apply the changes to the master configuration.
  9. Select the data source you just created and test the connection.
    1. Select the check box next to Cloudscape JDBC Driver XA DataSource.
    2. Click Test connection.

Result

If the connection is successful, the messages pane at the top of the window displays the following message: Test connection for data source Cloudscape JDBC Driver XA DataSource on server server 1 at node <node name> was successful.
Note: The test connection must be successful to run the rest of the tutorial.

Terms of use |


(c) Copyright IBM Corporation 2005, 2006.
This information center is powered by Eclipse technology (http://www.eclipse.org)