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 or a MS SQL Server Express database, use the following credentials:
Item
|
String
|
Driver Class
|
net.sourceforge.jtds.jdbc.Driver
|
Driver URL
|
- MS SQL Server
- jdbc:jtds:sqlserver://<HOST>:<PORT>/<DATABASE>
- MS SQL Server Express
- 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
- Only for MS SQL Server Express. Instance name of the database instance. The default MS SQL Server Express instance is
localhost\SQLExpress.
|