Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Enable Integrated Security for JDBC Data Sources

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 a data source/agent, you must perform additional tasks beyond the standard configuration steps.

Set up the Data Agent Service with Integrated Security

  1. Within
    Integration > Design Integrations
    , unprovision any agents from the host PC.
  2. Stop the Data Agent service.
  3. Reconfigure the windows service to run as the Windows account that has network/ db credentials.
    Example Adaptive Data Agent Service 64 bit Properties (Local Computer)
    • Log On
       tab settings:
    • This account:
      yourcompanydomain\yourusername
  4. Install the required DLLs.
    For either JTDS or JDBC
    The
    sqljdbc_auth.dll
     file installs as part of the data agent installer for agents V5.1.17.8415 and newer into
    C:\Program Files\Workday Adaptive Planning Data Agent\lib\mssqljdbc\x64
    .
    For agents older than V5.1.17.8415, you must manually install
    sqljdbc_auth.dll
    . The
    sqljdbc_auth.dll
     file is available from Microsoft download  https://www.microsoft.com/en-US/download/details.aspx?id=11774
    For JTDS
    Place the
    sqljdbc_auth.dll
     file somewhere in the
    PATH
    , such as
    C:\Windows\System32
    .
    For any Agent version, you must manually install the
    ntlmauth.dll
    .
    The required
    ntlmauth.dll
     for a JTDS jdbc driver (either x32 or x64 version depending on the JVM in use) should be placed in
    C:\Program Files\Workday Adaptive Planning Data Agent\lib\mssqljdbc\x64\
     (for 64 bit JVM).
    For data agent versions 7.1.44 and older,
    C:\Program Files\Adaptive Data Agent\lib\mssqljdbc\x64\
     (for 64 bit JVM)
    or
    C:\Program Files\Workday Adaptive Planning Data Agent\lib\mssqljdbc\x86\
     (For 32 bit JVM).
    The
    ntlmauth.dll
     file is available from a JTDS download location:
    For JDBC
    The JDBC driver requires
    sqljdbc_auth.dll
    .
    Manually place the
    sqljdbc_auth.dll
     in the
    <java>\jre\bin
     folder. The
    <java>
     directory must be the same as the one used when the Agent was installed.
    You can verify exactly what directory to use by examining the agent config file
    C:\Program Files\Workday Adaptive Planning Data Agent\ AgentService64.ini
    . Find
    "JRE Path"
     under [Java Runtime Environment] within this file. Copy
    sqljdbc_auth.dll
     into the directory listed for
    JRE Path
    .
  5. Re-start the Data Agent service.
  6. Re-provision the agent.
    Select
    Provision a New Agent
     in the Data Agent Service Manager.

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.