I'd like to know if it's possible to connect to a Sybase database using BIRT? I'm using BIRT with Rational Business Developer version 7.5.1. I'd like to know if it's possible to connect to a Sybase databases running on a Windows sever? I'm hung up on what JDBC driver to use, and what to put in for the Driver URL. It would appear we are using SQL Anywhere 9. I'm not sure if that is of any information or not. Any help would be greatly appreciated.
Page 1 of 1
Connecting to Sybase database
Rate Topic:
MultiQuote
#2
pboos 
- Newbie
-
- Group: Members
- Posts: 6
- Joined: 25-July 08
Posted 18 July 2011 - 11:50 AM
There is an open source JDBC driver that works with BIRT. It is the JTDS driver. You can download it from:
http://sourceforge.n...cts/jtds/files/
After you download, you need to click Manage Drivers when you set up your Data Source in the report and add the driver. Below is an example of what you need to use for the Driver class and URL:
Driver Class: net.sourceforge.jtds.jdbc.Driver (v1.2)
Driver URL: jdbc:jtds:sybase://<host>[:<port>][/<database_name>]
Example Driver URL: jdbc:jtds:sybase://host.domain.com:5000/ExampleDatabase
http://sourceforge.n...cts/jtds/files/
After you download, you need to click Manage Drivers when you set up your Data Source in the report and add the driver. Below is an example of what you need to use for the Driver class and URL:
Driver Class: net.sourceforge.jtds.jdbc.Driver (v1.2)
Driver URL: jdbc:jtds:sybase://<host>[:<port>][/<database_name>]
Example Driver URL: jdbc:jtds:sybase://host.domain.com:5000/ExampleDatabase
Page 1 of 1
