Windows authentication means creating a database connection to Microsoft SQL Server while leaving User and Password blank (see figure below). Accessing the MS SQL database, the JTDS driver uses your Windows account to log in. The JTDS driver depends on native libraries you have to install. To enable this all, follow the steps described in this section.
Figure 34.10. Connecting to MS SQL with Windows authentication.
CloverETL comes with a JDBC driver from JDTS.
However, it does not provide native libraries which are required
for JDTS to work with Windows authentication on Microsoft SQL Server.
Thus, it is necessary to
download the native dll
(ntlmauth.dll
) and perform some additional settings.
CloverETL supports JTDS v. 1.2.8. To download the driver follow these instructions:
Get the dist package.
Extract the contents and go to folder x64\SSO
, or x86\SSO
.
Copy the ntlmauth.dll
file (for 64b or 32b version of
CloverETL, respectively)
to a folder, e.g. C:\jtds_dll
Now there are two ways how to make the dll
work.
The first one involves changing Windows PATH
variables.
If you do not want to do that, go for the second option.
Add the absolute path to the dll
file
(C:\jtds_dll
) to the Windows
PATH
variable. Alternatively, you can put the
dll
file to some folder which is already included
in PATH
, e.g C:\WINDOWS\system32
.
Modify the java.library.path
property for all
members of the CloverETL Family of products:
Designer
Modify VM Parameters in the graph's Chapter 15, Runtime Configuration screen (see figure below). Add this line to VM parameters:
-Djava.library.path=C:\jtds_dll
![]() | Note |
---|---|
The runtime configuration is valid for all graph within the same workspace. |
![]() |
Figure 34.11. Adding path to the native dll
to VM parameters.
Clover Server
In the script that starts Tomcat, add the
-Djava.library.path=C:\jtds_dll
option to JAVA_OPT
.
For example, add the following line at the beginning
of catalina.bat
:
set JAVA_OPTS=%JAVA_OPTS% -Djava.library.path=C:\jtds_dll
MS SQL Server - make sure you have:
TCP/IP Enabled
in
→
TCP Port set to 1433 in TCP/IP → →