Geek Logbook

Tech sea log book

SODA: Connect SQL Server without Password

When you do your first steps using soda, it is possible you want to connect to an SQL Server database. In that case you can create an specific user and give him the proper rights I wrote about that in the following post: Connect Soda to SQL Server. But, Is it possible to use the windows authentication, so you don’t have to use a password. In the official documentation of SODA: Link to the official Documentation you can find the following for trusted_connection:

The default value is false. Set to true if using Active Directory authentication.

Soda official Documentation

So, if you set the “Trusted connection” to True It won’t be necessary to create the user. The YML file should be similar to this one:

data_source adventureworks:
  type: sqlserver
  host: localhost
  port: '1433'
  username: notmatterwhatyouwrite
  password: notmatterwhatyouwrite
  database: AdventureWorksLT2019
  schema: SalesLT
  trusted_connection: true
  trust_server_certificate: false
  driver: 'ODBC Driver 17 for SQL Server'

And the result of that is a valid connection:

soda test-connection -d adventureworks -c configuration.yml -V

Leave a Reply

Your email address will not be published. Required fields are marked *.

You may use these <abbr title="HyperText Markup Language">HTML</abbr> tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>