Enabling Encryption for DataHub Connection to SQL Server Database

getting-started
1

Original Slack Thread

I am trying to test out DataHub and connect to a SQL Server Database. My connection information is as follows:
source:
type: mssql
config:
host_port: ‘***********************:1433’
database: Prod
username: ****************************
include_views: true
include_tables: true
profiling:
enabled: true
profile_table_level_only: false
stateful_ingestion:
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

2

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

3

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