Connecting to Sybase database

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.

Find more posts tagged with

Comments

pboos

There is an open source JDBC driver that works with BIRT. It is the JTDS driver. You can download it from:

http://sourceforge.net/projects/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