Thursday, February 17, 2011

How to access BPEDB using WebSphere Integration Developer (WID 6.2)

When developing Human Tasks for the IBM WebSphere Process Server 6.2 (WPS 6.2) and WebSphere Integration Developer 6.2 (WID 6.2) occasionally you want to see how the data are physically stored in the database.  Out of the box, the database that stores these data is Derby and the database name is BPEDB.

If you have a need (like I did) to view BPEDB to see the human tasks data that belong to a business process using WebSphere Integration Developer (WID) 6.2, here's how you do it:

1. In WID, open the "Database Development" perspective.



2. In the Data Source Explorer, right click on "Database Connections" and select "New"









3. In the connection parameters window, select "Derby" as a database manager, select "Derby 10.x - Embedded JDBC Driver Default" - in my case it's 10.2, and browse for the location of your BPEDB.This should be in your server profile. eg: [installation dir]\WID62\profiles\server1\databases\BPEDB or something similar. In my test environment, I left user name and password are blank. Click test connection to make sure you can connect, before you click finish.



And voila... that's all, now you can see the content of your human tasks data.  Just remember, you should leave data modification via the API. The data should be treated as read only to gain better understanding and debugging.






And that's all folks... Easy once you figure it out.. :p