|
Re: Importing or creating a database with BIRT [message #1060877 is a reply to message #1060695] |
Tue, 28 May 2013 19:39 |
Kristopher Clark Messages: 130 Registered: January 2013 |
Senior Member |
|
|
To connect to a db like mySQL from BIRT you'll need to create a new data source. You'll want to select "JDBC Data Source". Next you'll need to tell BIRT what driver you're wanting to use, for mySQL I use com.mysql.jdbc.Driver (v5.1).
Next you'll need to provide it a url to your database, if mySQL is on the same machine that you are creating the reports on it'd be something like
jdbc+mysql://localhost:3306/databasename
Then you'll need to give it your user name and password. You should test the connection first with the test connection button to make sure everything is correct.
After you've created a data source you can create a new data set. You'll have to provide it a query, a simple one would be something like
select *
from TABLE_NAME
If you're wanting to connect to another type of db you can select it while creating your data source in the first prompt.
If you need help with your SQL query http://dev.mysql.com/doc/refman/5.0/en/select.html is a good site that you might want to look over.
[Updated on: Tue, 28 May 2013 19:41] Report message to a moderator
|
|
|
|
Powered by
FUDForum. Page generated in 0.04135 seconds