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:
35.188.163.165
34.122.126.216
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.
Example:
-----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=
-----END CERTIFICATE-----
Adding SQL Server System in Savant
Once you’ve completed the steps above, follow these steps in Savant:
Go to the Systems page and click Add System
Select the SQL Server connector and click Next
Enter your system information and credentials from above
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.
Select which Object you would like to import into your data source from the drop down menu.
Select which Columns you want to include in the dataset.
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!