Datagaps ETL Validator v3.4.3 and later versions come with the JTDS JDBC driver to connect with SQL Server. There are two options to setup a connection to SQL Server :
- SQL Server Authentication
- Windows Authentication.
Using SQL Server Authentication is straight forward assuming that the SQL Server is setup to accept this type of authentication mechanism. However, Windows Authentication is often the only available mechanism for connecting to SQL Server. There are a couple of manual steps involved to ensure that you have a successful connection using Windows Authentication.
- Download JTDS Driver package from the website here : http://sourceforge.net/projects/jtds/files/jtds/1.3.1/. Extract the JTDS Driver package and copy the 64-bit or 32-bit version of the ntlmauth.dll file to the JRE bin directory.
Note: This step is not required for ETL Validator Complete. The embedded JRE in ETL Validator already has this file.
- Open Windows Services and select the 'datagaps ETL Validator Server' service. Right click on it to open the properties. Navigate to the 'Log On' tab and change the user name to the windows user as shown below. Provide the Windows domain/user name and password for windows authentication. This step is needed because by default ETL Validator Server is installed to run as the local system account. In order to use Windows authentication, the ETL Validator Server process needs to be run as the Windows user:
- Restart 'datagaps ETL Validator Server' service so that the new settings take into effect.
- Create a connection from ETL Validator for SQL Server and pick the Windows Authentication option. The user name and password can be left blank.