Databases

Connecting to SQL Server

DO NOT connect to your production database! Tests will WRITE to your staging databases!

To connect to your source SQL Server staging database, first click the Settings button in the Home tab.

Select the Database connections tab, and in it, Source staging.

Please note you may need to allow our IP address to connect. You can use either SQL Server authentication, or Service Principal. We recommend Service Principal because you can use a short-lived token, which is more secure.

Next
Connecting to SQL Azure

If this was useful,
our newsletter will be too.

Get monthly insights on data engineering, AI, and building critical infrastructure - direct from the Spectral Core team and CEO Damir Bulic.