Skip to main content
All CollectionsSystem Setup Guides
SQL Server Connector Setup
SQL Server Connector Setup
Updated over a week ago

Welcome to the SQL Server Connector Setup guide!

In this article, we will cover the following:

  • Authenticating SQL Server in Savant

  • Connecting Data from SQL Server

Authenticating SQL Server in Savant

IP Whitelisting

Savant accesses your SQL Server from two IP addresses:



If your network is configured to only allow access from certain IPs, include these in your whitelist.

Create a Savant User in SQL Server

We recommend creating a specific user and role for Savant with permission to access the required table(s) in SQL Server. If you already have a user and role created with appropriate permissions, you can skip this step.

CREATE USER 'savant_user'@'%' IDENTIFIED BY 'password';

Grant Permissions in SQL Server

Grant the Savant user privileges to access all tables.

Run these commands to grant permissions to the Savant role:

GRANT ALL ON schema.* TO 'savant_user'@'%'; // read and write

Check Permissions in SQL Server

Run these commands to check privileges to the Savant role:

SHOW GRANTS FOR 'savant_user'@'%'; // check grants

Adding System to Savant

SSL (Recommended)

If you turn on SSL, and you are using a self-signed certificate like below, you need to upload to savant.


-----BEGIN CERTIFICATE----- MIIDHzCCAgegAwIBAgIUFrpVEmv/6tsiiiuDXaxpEW4mNhUwDQYJKoZIhvcNAQEL BQAwHzEdMBsGA1UEAwwUKi5zcWwuc2F2YW50LWRldi5uZXQwHhcNMjIwMzI2MTM1 NjQzWhcNMjMwMzI2MTM1NjQzWjAfMR0wGwYDVQQDDBQqLnNxbC5zYXZhbnQtZGV2 Lm5ldDCCASIwDQYJKoZIhvcNAQEBBQADggEPADCCAQoCggEBAL57IDUoPLtIpheL LiOcc2xIBhtMZfE4g4CCmbetwoIJXYptbxld/lS7xbOgdpWK0FMpuIg5x+NBWfqw bLnp0/2INP/78LO4U5aAJp3m45mNRKWzAKMtcrX7kW4OfL2DcaIb5vKkFY+Y3oDr 3JVsnOfbx5vS2ppfIuQEKX+gRoijTEaMxQoyaV6MSsJ9HVMidlKG+4KO3/V29Wst rvGbbSnS5rvFIgGTahcwMa7C/pngGTbGZW8gUE21G2e7Iq1Lv7y7Yw89xW227ttG T84BdsTjSVAFgaddENftSSsHUrlsKUfV1VqjQpyxEXPI3wLFR/0LaWaJl571EONm eNjV4+UCAwEAAaNTMFEwHQYDVR0OBBYEFIYXUucb43NG/HFwqtsSbdLtGCWVMB8G A1UdIwQYMBaAFIYXUucb43NG/HFwqtsSbdLtGCWVMA8GA1UdEwEB/wQFMAMBAf8w DQYJKoZIhvcNAQELBQADggEBAES5WrvFbRNILSMTdK39DcKBzhKTQ4GhPA8PrhxR cNZQl7zqEzSxNaVRGTJlOEuUNAr2gnInnCT0CsraQ56f2glJWryQUoR0TDJvH1QY KJJcyBBfYZaeNyuY+anNJgleIiZ3HD5H5/3Dr0hXhJKUH8O0/G1hNeVbilsgeApv 3T8hb/VcraeoHEDW39rleu2U0iosLgAbiC1SBwPu2xRSzZKjOU3X5FvahsG+aZfF 6KvcCAFYzR70RMo8bHhthh3F/6PoV4YIsoS1YbrHGt1T2GbrKJrdZfqO+IiQn7a0 r5BWz7FvduCH//L8TIW+ovB+mrEMzVP6KTn5EQhD2oKiBVA=


Adding SQL Server System in Savant

Once you’ve completed the steps above, follow these steps in Savant:

  1. Go to the Systems page and click Add System

  2. Select the SQL Server connector and click Next

  3. Enter your system information and credentials from above

  4. Click Authenticate and then Confirm

Connecting Data from SQL Server

On the top left side of your canvas, click the Add Source button, shown below and select your new Shopify connection.

If you are not currently within an analysis, you can add your connection by navigating to Data and selecting New Dataset. Select your previously authenticated Shopify system from the list of available options and click Next.

Now you can configure the dataset and decide which data from various objects you would like to import into your analysis.

  1. Select which Object you would like to import into your data source from the drop down menu.

  2. Select which Columns you want to include in the dataset.

  3. Once you're done, click Next.

Next, add a name and description to your data set to be used within your canvas and click Confirm.

Your data from SQL Server is now placed on your canvas as a source for your analysis!

Did this answer your question?