Connecting to SQL-Server with Windows Auth from Elixir
The goto method to connect to databases in Elixir are the Ecto adapters. Connecting to the SQL-server is done using the TDS adapter. Unfortunately, TDS does not support windows authetication.
The way to overcome this limitation is to use the erlang ODBC library.
def get_data do
{:ok, ref} = :odbc.connect …