RSS

BIRT: Connecting to MS Sql Server Database

17 Feb
POSTED BY 
  1. Download the Microsoft JDBC driver fromhttp://msdn.microsoft.com/en-us/sqlserver/aa937724
  2. Note: If youre using Java 1.5, you will use sqljdbc.jar, if your using Java 1.6, you will use sqljdbc4.jar.
  3. Open Eclipse
  4. Create a new Report or open an existing report
  5. Open the Data Explorer Tab
  6. If this is an existing report, Double Click on an existing Data Source, otherwise create a new Data Source. Call it whatever.
  7. From the Data Source editor, click on the Manage Drivers button.

 

  1. In the Manage JDBC Drivers Dialog, click on Add…

 

  1. Navigate to where you have either the sqljdbc.jar or sqljdbc4.jar file, and click Open. This will add the driver to the BIRT Designer.
  2. Now, click on the Drivers Tab.
  3. Double click on the SqlServerDriver entry to edit it. Put in a name, and a URL template that will prompt you on the correct URL pattern to use.

 

  1. Click on OK, and OK, until you get to the Data Source Editor Dialog.
  2. Select the SQL Server driver from the drop down list. It will automatically put in the template. Replace the IP Address, and Database name with the ip of your Sql Server Database, and the name of the database.

 

  1. Enter the correct User Name and Password.

 

That’s it, your done. Test Connection to make sure the information is correct, and hit OK.

Referenced by: http://digiassn.blogspot.com/2011/03/birt-connecting-to-ms-sql-server.html

Advertisements
 
Leave a comment

Posted by on February 17, 2012 in Birt Report

 

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: