Enabling Encryption for DataHub Connection to SQL Server Database

Original Slack Thread

I am trying to test out DataHub and connect to a SQL Server Database. My connection information is as follows:
type: mssql
host_port: ‘***********************:1433’
database: Prod
username: ****************************
include_views: true
include_tables: true
enabled: true
profile_table_level_only: false
enabled: true
password: *******************

How do enable encryption in this setup? I have looked at documentation but it appears that maybe the only way to do it is via ODBC. Any help someone could provide would be appreciated. I have been using the documentation from at https://datahubproject.io/docs/generated/ingestion/sources/mssql

Here is the error:
Command failed: Failed to configure the source (mssql): (pytds.tds_base.Error) Client does not have encryption enabled but it is required by server, enable encryption and try connecting again

<@U01GZEETMEZ> might be able to speak to this!

Yes mssql encryption currently requires using ODBC. The latest versions have experimental support for CA files using pytds (see the sample recipe here https://datahubproject.io/docs/next/generated/ingestion/sources/mssql#starter-recipe), but it’s something the community added and I haven’t tested myself yet