IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Back to Library

Adapter for JDBC Connections with Azure (Active Directory) 

Tue December 06, 2022 03:36 AM

products versions - webMethods Adapter version: 10.5 and 10.7 and 10.11

To prepare to configure or manage adapter connections:

  1. Install webMethods Integration Server and Adapter for JDBC on the same machine.

  2. Install a compatible JDBC driver. You must install a JDBC driver on Integration Server before you can specify connections. Integration Server requires access to the Java classes for each JDBC driver that it will use to connect to a database. For a list of supported drivers, see webMethods Adapters System Requirements.
    → To install a JDBC driver
    a. Download below list of jar files:

    image

b. Place the Java classes for the JDBC driver in a location that Integration Server can access, typically the server’s classpath. To place the classes in the server’s classpath, place the .jar file containing the classes in the Integration Server_directory\instances\instance_name\packages\WmJDBCAdapter\code\jars directory.

c. Restart the Integration Server.

The server automatically adds the .jar libraries to its classpath after the restart.

  1. Make sure you have Integration Server administrator privileges so that you can access Adapter for JDBC’s administrative screens.
  2. Start your Integration Server and Integration Server Administrator, if they are not already running.
  3. Using Integration Server Administrator, make sure the WmJDBCAdapter package is enabled.
  4. Using Designer, create a user-defined package to contain the connection, if you have not already done so.

Configuring Adapter for JDBC Connections

When you configure Adapter for JDBC connections, you specify the information that Integration Server uses to connect to a JDBC system. You can configure Adapter for JDBC connections using the Integration Server Administrator.
To configure an adapter connection

  1. In the Adapters menu in Integration Server Administrator’s navigation area, click webMethods Adapter for JDBC.
  2. On the Connections screen, click Configure New Connection.
  3. On the Connection Types screen, click webMethods Adapter for JDBC Connection to display the Configure Connection Type screen.
  4. In the webMethods Adapter for JDBC section, configure the following fields:
Package Package in which to create the connection. Use Designer to create the package before specifying the value in this field.
Folder Name Folder in which to create the connection.
Connection Name Name you want to give to the connection. Connection names cannot have spaces or use special characters reserved by Integration Server and Designer.
  1. In the Connection Properties section, use the following fields:

image
image870×486 21.3 KB

  1. Click Save Connection.

The connection you created appears on the adapter’s Connections screen and in Designer. You can enable a connection only if the parameters for the connection are valid.

image
image939×658 93.9 KB

Please find the below table for SQL Server driver JAR version supported with webMethods product:

Product version JDBC driver version
WebM1011 mssql-jdbc-7.2.2.jre11.jar and above
WebM107 mssql-jdbc-7.2.2.jre8.jar and above
webM105 mssql-jdbc-7.2.2.jre8.jar and Above

Note: sqljdbc42.jar and above is working with webM105 product with below Other Properties input.

authentication=ActiveDirectoryPassword;trustServerCertificate=false;hostNameInCertificate=<hostname certificate>;IntegratedSecurity=false|


#webMethods

Statistics
0 Favorited
1 Views
0 Files
0 Shares
0 Downloads