The BIRT sample database provides a simple set of tables and data that form the basis for BIRT sample reports. The schema is for Classic Models, a retailer of scale models of classic cars. The database contains typical business data such as customers, orders, order line items, products and so on. It was designed to illustrate many of the features of the BIRT report designer.
The sample database is open source; you are free to use it for your own use to experiment with other tools; to create samples for other tools, etc. The sample database is provided under the terms Eclipse.org Software User Agreement.
The database consists of eight tables:
This ER-diagram shows the table structure and relationships. (PDF version)
The sample database is available in two forms:
The scripts to load a MySQL database are contained in the sample database zip file. This zip also has documentation and logos for the sample database.
To install the MySQL version of the sample database, you must have MySQL installed. See mysql.com for instructions.
Install the MySQL JDBC driver into BIRT:
You are now ready to create the Classic Models database:
Following is the Derby Database localized into French, German, Spanish, Japanese, Korean, and Simplified Chinese.
You can now use the sample database within BIRT to create reports. The key information you need to get started is how to create a data source for the database. The details vary depending on the database system you selected.
The Apache Derby version of the database is included in the BIRT download as a built-in data source. To access it, simply select the "Classic Models Inc. Sample Database" entry in the new data source dialog.
Data source properties for the MySQL sample database:
Driver Class: | com.mysql.jdbc.Driver |
URL: | jdbc:mysql://localhost/classicmodels |
User Name: | root |
Password: |