Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

Enable Integrated Security for JDBC Data Sources

Two JDBC drivers (JTDS and MS SQL Driver) support Integrated Security with MS SQL Server.

To enable Integrated Security in an Adaptive data source/agent, three tasks need to be performed in addition to the standard configuration steps.

For the on-premise agent:

  1. Place the required driver’s dll in the agent system path before the agent starts.
  2. Configure the Agent service Logon On property with the proper domain user/password.

For the data source:

  1. The JDBC url entry needs the additional IntegratedSecurity=true property

Set up Adaptive Data Agent Service with Integrated Security

  1. Within Integration > Data Designer, unprovision any agents from the host PC.
  2. Stop the Adaptive Data Agent service.
  3. Reconfigure the windows service to run as the Windows account that has network/ db credentials.
    AdaptiveIntegration_integrated_security_account.png
  4. Ensure the required DLLs (sqljdbc_auth.dll, ntlmauth.dll) are copied into the appropriate destination.

For agents V51.17.8415 and newer, sqljdbc_auth.dll is automatically deployed by the Agent installer, users do NOT need to manually add this DLL.

The x64 version of the DLLs should be in C:\Program Files\Adaptive Data Agent\pdirunner\lib\libswt\win64\ if this is a 64 bit JVM in use for the agent.

The 32bit version of the DLLs should be in C:\Program Files\Adaptive Data Agent\pdirunner\lib\libswt\win32\ if this is a 32 bit JVM in use for the agent.

sqljdbc_auth.dll is available from Microsoft download
https://www.microsoft.com/en-US/download/details.aspx?id=11774

ntlmauth.dll is available from a JTDS download location
https://sourceforge.net/projects/jtds/files/jtds/1.2.5/ for jtds 1.2.5
https://sourceforge.net/projects/jtds/files/jtds/1.2.8/ for jtds 1.2.8
http://sourceforge.net/projects/jtds/files/ for jtds 1.3.1

  1. Re-start the Adaptive Data Agent service.
  2. Re-provision the agent using the Agent Service Manager.
    Adaptive Integration Enable Integrated Security Reprovision Agent

Creating a JDBC Data Source

When you create a JDBC data source using the Create New Data Source menu, make sure to include the integratedSecurity=true in the JDBC url.

For the MS SQL driver:

Driver class:
com.microsoft.sqlserver.jdbc.SQLServerDriver
Jdbc url:
jdbc:sqlserver://<server>:<port>;integratedSecurity=true
Example:
jdbc:sqlserver://dev-gp2013-r2:1433;integratedSecurity=true
User name: keep it empty
Password: keep it empty

For the JTDS driver:

Driver class:
net.sourceforge.jtds.jdbc.Driver
Jdbc url:
jdbc:jtds:sqlserver://<server>:<port>;integratedSecurity=true;domain=<domain name>
Example:
jdbc:jtds:sqlserver://DEV-GP2013-R2:1433;integratedSecurity=true;domain=ADAPTIVE
User name: keep it empty
Password: keep it empty

  • Was this article helpful?