Creating the JDBC provider

About this task

To establish access to your MS SQL database you must create a JDBC provider for MS SQL access.

To create the JDBC provider complete the following steps:

Procedure

  1. Select Resources > JDBC > JDBC Provider.
  2. Select Scope and choose the one which has Node and Server.
  3. Click New.
  4. Specify the JDBC provider information.
    Database type
    Set to SQL Server.
    Provider Type
    Set to Microsoft JDBC Driver .
  5. Select Connection pool data source.
  6. Click Next.
  7. To accept the path to the jar files, click Next.
  8. Click Finish.
  9. Click Save.