mirror of
https://github.com/datahub-project/datahub.git
synced 2025-07-05 08:07:04 +00:00
53 lines
1.4 KiB
YAML
53 lines
1.4 KiB
YAML
source:
|
|
type: mssql
|
|
config:
|
|
# Coordinates
|
|
host_port: localhost:1433
|
|
database: DemoDatabase
|
|
|
|
# Credentials
|
|
username: user
|
|
password: pass
|
|
|
|
# This is recommended to improve lineage quality. Ignores case-sensitivity when constructing internal identifiers.
|
|
convert_urns_to_lowercase: True
|
|
|
|
# Options
|
|
# Uncomment if you need to use encryption with pytds
|
|
# See https://python-tds.readthedocs.io/en/latest/pytds.html#pytds.connect
|
|
# options:
|
|
# connect_args:
|
|
# cafile: server-ca.pem
|
|
# validate_host: true
|
|
|
|
sink:
|
|
# sink configs
|
|
|
|
#------------------------------------------------------------------------
|
|
#Example: using ingestion with ODBC and encryption
|
|
#This requires you to have already installed the Microsoft ODBC Driver for SQL Server.
|
|
#See https://docs.microsoft.com/en-us/sql/connect/python/pyodbc/step-1-configure-development-environment-for-pyodbc-python-development?view=sql-server-ver15
|
|
# ------------------------------------------------------------------------
|
|
|
|
source:
|
|
type: mssql-odbc
|
|
config:
|
|
# Coordinates
|
|
host_port: localhost:1433
|
|
database: DemoDatabase
|
|
|
|
# Credentials
|
|
username: admin
|
|
password: password
|
|
|
|
# Options
|
|
use_odbc: "True"
|
|
uri_args:
|
|
driver: "ODBC Driver 17 for SQL Server"
|
|
Encrypt: "yes"
|
|
TrustServerCertificate: "Yes"
|
|
ssl: "True"
|
|
|
|
sink:
|
|
# sink configs
|