Where I locate the sample database?

I was asked to add columns and tables to the sample database, is it possible? But I couldnt locate the database in any of the folder can someone please advise me?

if I were to create my own database, how can I go along doing that?

Thanks so much

Find more posts tagged with

Comments

bhanley

The sample database is a Derby DB embedded in a JAR. You will probably have an easier/faster time creating your own data source. It can be something as simple as a CSV or XML file all the way up to a relational database. Once you create the source data, BIRT should be able to consume it easily. Let me know what type of data source you intend to create and we can wal through the specific process to get it configured inside BIRT.

catherine

hi thanks brian.

Actually i just need to set up a simple database which consist of maybe student admin number, student first name, student last name, course of study, and module name.

Just a few. Just a simple database and I can only pass my presentation if I can present it with a simple database created by myself and when I insert it into the table, the data will be retrieve and shown.

Can you please guide me how can I create a data base myself? Really appreciate that.

Thanks,
Catherine

bhanley

A CSV would be the simplest solution. Does your work require a relation database? If not, just create a CSV file with some data in it. Then you can create a new flat file data source in BIRT and consume the CSV file. Your data will then be accessible so you can build components like charts and tables.

catherine

Hi is there any tutorial on how can i create a csv file? Where can I start doing a csv file? Thanks

bhanley

A CSV is a text file where each line has a "row" of data with the fields separated by commas. You can create it by hand very quickly and easily.<br />
<br />
Here is some background: <a class='bbc_url' href='http://en.wikipedia.org/wiki/Comma-separated_values'>Comma-separated values - Wikipedia, the free encyclopedia</a>

catherine

hi thanks for your reply. Just to check with you, I can create it with notepad and save it as for example, database.csv? Thanks so much

Catherine

bhanley

Yes, you can certainly do that. It is a simple plain text file.

catherine

Hi thanks brian. I will try to do it. Thanks for your help

catherine

Hi brian. I have created a simple file (student.csv) with the following:

admin_nbr, first_name, last_name
062838R, Catherine, Tok
062756B, Melissa, Ng

How do I connect the data source and data set to this? Is this considered a xml file? I tried to connect but a error prompted stating this is not a xml file.

could you please advise me?

Thanks so much

Catherine