I had to recently had to get visibility to my WebSphere Business Monitor database in my WID server configuration. This database gets installed when you install the Monitor Toolkit into your WID environment. In my case, I was using a Derby database but this method can be used for any database type.
From inside WID:
- Switch to your Database Development perspective
- From the Data Source Explorer, right click on the Database Connections and click on New
- Select Derby as your database manager
- Select Derby 10.0 - Embedded JDBC Driver Default for your JDBC data source
- Browse to the WID Derby database directory that you want connect to. In my case I wanted MONITOR so I entered: <WID_install_root>\pf\WBMonSrv_wps\databases\MONITOR
- Enter the user name and password (I entered my Windows user name and password)
- Uncheck the Create database (if required) checkbox
- Check the Save password checkbox
Now you can drill down to your schemas and view and edit the contents of your database tables.