Can someone give me the summary of right parameters and corr

The error I am getting when I try configuring a database connection to an SQL server is as follows.

The JDBC DataSource class “” cannot be located. not founduser sa

Here’s the set of parameters I specify (note the 4 \ in the server name to actually represent a server - \XYZ)

Connection Type: JDBC Adapter Connection
Package Name: abc
Connection Properties
Transaction Type: NO_TRANSACTION
DataSource Class:
serverName: \\XYZ
password ******
portNumber 1433
Other Properties
Connection Management Properties
Enable Connection Pooling true
Minimum Pool Size 1
Maximum Pool Size 10
Pool Increment Size 1
Block Timeout (msec) 1000
Expire Timeout (msec) 1000
Startup Retry Count 0
Startup Backoff Timeout (sec) 10

You will need to install the drivers on the IS.

  1. Download the SQL Server drivers from microsoft

  2. Put the downloaded files in the /IntegrationServer/lib/system directory

  3. Restart the IS

Thank you very much Brian. It helped. The absence of jar files from the IntegrationServer\lib\jars folder was causing problems.