Use the BIRT
New JDBC Data Source Profile dialog box to establish database access to an existing
Performance Manager 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.
|