Set up a database for a dashboard application

 

To store portlet data, we can use the Cloudscape™ database that comes with the WebSphere Dashboard Framework or set up a database in IBM^® DB2 Universal Database™.

Follow the steps for the database you want to use.

 

• Copying the sample application files to the application server
  The sample application zip file needs to be located on the application server before we can set up a database.

   

• Setting up a Cloudscape database
  IBM WebSphere^® Dashboard Framework includes a pre-populated Cloudscape database and JDBC driver for use with the sample application. The calendar also supports a Cloudscape database.

   

• Setting up a DB2 database
  To use DB2, create a database. The tables and data can be created by executing the SQL script included in IBM WebSphere Dashboard Framework.

   

• Setting up an Oracle database
  To use Oracle, create a database. The tables and data can be created by executing the SQL script included in IBM WebSphere Dashboard Framework.

   

• Setting up a SQL Server database
  To use Microsoft^® SQL Server, create a database. The tables and data can be created by executing the SQL script included in IBM WebSphere Dashboard Framework.

   

• Configuring a database persistence manager
  Create an override.properties file for a project to configure a database persistence manager for alerts and annotations.

Parent topic: Setting up dashboard features

---

Library | Support | Terms of use |

Last updated: Thursday, March 15, 2007 11:57am EST

This information center is powered by Eclipse technology. (http://www.eclipse.org)