BIRT Data Source Settings

Use the BIRT New JDBC Data Source Profile dialog box to establish database access to an existing Silk Central repository. To access the New JDBC Data Source Profile dialog box, right-click Data Sources in the Outline pane, click New Data Source, select JDBC Data Source, and click Next >.

To connect to a MS SQL Server database, use the following credentials:

Item	String
Driver Class	net.sourceforge.jtds.jdbc.Driver
Driver URL	MS SQL Server (default instance) jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE> MS SQL Server (named instance) jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE>;instance=<INSTANCENAME> HOST Host name or IP-address of the computer hosting the database server. PORT Port number of the database management system. Default is 1433. DATABASE The name of the database. INSTANCENAME Instance name of the database instance. The default MS SQL Server Express instance is SQLExpress.

Item

String

Driver Class

net.sourceforge.jtds.jdbc.Driver

Driver URL

MS SQL Server (default instance): jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE>
MS SQL Server (named instance): jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE>;instance=<INSTANCENAME>

HOST: Host name or IP-address of the computer hosting the database server.
PORT: Port number of the database management system. Default is 1433.
DATABASE: The name of the database.
INSTANCENAME: Instance name of the database instance. The default MS SQL Server Express instance is SQLExpress.

To connect to an Oracle database, use the following credentials:

Item	String
Driver Class	oracle.jdbc.OracleDriver
Driver URL	jdbc:oracle:thin:@<HOST>:<PORT>:<DATABASE> HOST Host name or IP-address of the computer hosting the database server. PORT Port number of the database management system. Default is 1521. DATABASE Oracle SID.