dsn-instructions.md

Database Connection Instructions

This document provides instructions on how to connect to different types of databases using Data Source Names (DSNs) in our project.

Supported Databases

• Postgres
• MySQL
• Snowflake
• SQL Server
• File-based databases

General DSN Format

[database_type]://[username]:[password]@[host]:[port]/[database_name]

Database-Specific Instructions

PostgreSQL

DSN Format

postgres://[username]:[password]@[host]:[port]/[database_name]

MySQL

DSN Format

mysql://[username]:[password]@[host]:[port]/[database_name]

Snowflake

DSN Format

snowflake://[username]:[password]@[host]/[database_path]

See this article for more examples on linking a snowflake db to Dataline.

SQL Server

DSN Format

mssql://[username]:[password]@[host]:[port]/[database_name]?driver=[driver_name]&TrustServerCertificate=yes

Example driver_name: ODBC+Driver+18+for+SQL+Server. Note that spaces are replaced by plus signs +.
Make sure the driver you specify in the DSN is installed locally on the device running Dataline. Driver installation instructions can be found here.

File-based databases

You can simply upload the file into Dataline when creating a new connection!