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.

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.