Once you have created the FFDB database, you must configure WebSphere® Integration
developer to recognize it as the data source.
- Open WebSphere Integration
Developer. The Business Integration perspective
will open by default.
- On the bottom right corner of the Business Integration perspective,
click on the Server tab to bring it to the front.
- Right-click your server instance and select Start.
- 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.
- 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.
- In the user ID field, enter the default
administrative user ID admin and click Log
in.
- 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.
- In the left pane of the administrative console, select . Confirm that Node: widNode is selected in the JDBC
providers pane.
- Select the check box for Cloudscape JDBC Provider
(XA) and click New.
Figure 1. New JDBC providers pane
- 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
- Click OK in the General Properties window.
- Click Cloudscape JDBC Provider (XA),
then click Data Sources from the right pane of the
window.
Figure 3. Data sources
selection window
- Select New and then type DB2JNDI in
the JNDI name field.
- Scroll down to the Database name field
and type FFDB.
- Click OK.
- Click Save to apply the changes to the master
configuration.
- Select the data source you just created and test the connection.
- Select the check box next to Cloudscape JDBC Driver
XA DataSource.
- 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.