API Gateway: Active Directory Integrated Authentication Support for JDBC Connection Pool

Products

• CA API Gateway

Issue/Introduction

Does the JDBC connection pool in API Gateway support AD Integrated authentication for the Microsoft SQL server?

Environment

Release : 10.0 and above

Component : API GATEWAY

Resolution

The Gateway uses the DataDirect drivers for connecting to the Microsoft SQL Server. This driver does offer many authentication options for connection to the SQL server including AD integrated authentication. Hence, the Gateway also supports the AD integrated authentication for the JDBC connection pool for the SQL server.

Here is an example of the JDBC connection pool properties that supports Active Directory Integrated authentication:

Driver Class: com.l7tech.jdbc.sqlserver.SQLServerDriver

JDBC URL: jdbc:l7tech:sqlserver://<SQL_SERVER_HOST>;AuthenticationMethod=ntlmjava;Domain=<AD_DOMAIN_NAME>

User Name: AD User name from the AD_DOMAIN_NAME (used in the JDBC URL)

Password: Password for the AD User

 

Additional Information

The DataDirect driver documentation has more information on the supported authentication methods. You can read more about this here: https://docs.progress.com/bundle/datadirect-connect-jdbc-51/page/AuthenticationMethod_6.html#AuthenticationMethod_6