Does the JDBC connection pool in API Gateway support AD Integrated authentication for the Microsoft SQL server?
Release : 10.0 and above
Component : API GATEWAY
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
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