Connect to On-Premise SQL Server with NTLM Authentication

In order to connect Workato to an on-premise Microsoft SQL Server database which requires NTLM authentication, these are the required steps:

1. Add sqljdbc_auth.dll file to workato's OPA jre/bin directory. You can find this file inside Microsoft SQL Server JDBC Driver 6.4, available for download here.
2. Remove username & password tags and add integratedSecurity:true  to your SQL Server profile on conf/config.yml
3. Your configuration should look like this:

# Example on premise SQL Server NTLM configuration
database:
   ntlmsqlserver:
     adapter: sqlserver
     host: <hostname>
     port: <port>
     database: <db>
     timeout: 30
     integratedSecurity: true

Note: if you are running Workato's OPA as a Windows Service, be sure to check which account is being used. By default, newly configured services run as "Local System", which is a system account with no permissions at all.