Microsoft SQL Server

Microsoft SQL Server is a relational database management system developed by Microsoft. As a DinoAI agent environment in Paradime, SQL Server enables running dbt™ models and queries during DinoAI background agent sessions.

IP RESTRICTIONS

Make sure to allow traffic from one of the Paradime IPs in your firewall depending on the data location selected.

👉 See also: Paradime IP addresses.

Setup Instructions

1. Click Settings in the top menu bar of the Paradime interface to access Account Settings

2. In the left sidebar, click Connections

3. Click Add New next to the DinoAI Background Agent Environment section

4. Select SQL Server

5. In the Profile Configuration field, add at least these required parameters. For additional configuration options, see the Profile Fields Reference section.

driver: 'ODBC Driver 18 for SQL Server'     # ODBC Driver 18 for SQL Server
server: sql.company.com                     # Hostname or IP address
port: 1433                                  # Default: 1433
database: analytics_db                      # Name of the database
user: sql_user                              # DinoAI agent service user
password: your_password                     # Service user password

After adding the configuration, ensure it's properly formatted using a YAML formatter like YAML Formatter.

1. Provide a dbt™ Profile Name (this should match the profile name set in your dbt_project.yml).

2. In the Target field, enter dinoai. This is the target your dbt™ project will use during DinoAI background agent sessions.

3. The Schema field is pre-configured, but you can change it to specify the schema where dbt™ will build objects.

4. The Threads value is pre-configured to 1, but you can adjust this to specify how many parallel operations your dbt™ project can run.

---

Example Profile Configuration

---

Profile Fields Reference

Field	Description	Example	Default Value	Required
driver	ODBC driver	ODBC Driver 18 for SQL Server	ODBC Driver 18 for SQL Server	✅
server	Server hostname or IP	sql.company.com	None	✅
port	Server port number	1433	1433	✅
database	Database name	analytics_db	None	✅
schema	Schema name. Configured in the UI Schema field.	dbo	None	✅
user	Authentication username for the DinoAI agent service user	sql_user	None	✅
password	Authentication password for the DinoAI agent service user	your_password	None	✅
retries	Number of query retry attempts	3	1	❌
encrypt	Enable connection encryption	true	true	❌
trust_cert	Trust server certificate	false	false	❌
login_timeout	Connection timeout in seconds	10	0	❌
query_timeout	Query timeout in seconds	300	0	❌
schema_authorization	Schema owner principal	db_owner	None	❌