Skip to content

SQL Server Guide

Screenshot

It only takes a few minutes to get started with Satori. What you need is:

  • Access to Satori's management console.
  • The hostname of your SQL Server data store, for example: abc123.database.windows.net

Adding a SQL Server Data Store to Satori

  1. Login to Satori's management console at https://app.satoricyber.com.
  2. In the Data Stores view, select Add Data Store.
  3. Select the SQL Server option.
  4. Enter an informative name for the data store, for example: Sales Data Warehouse.
  5. Enter the hostname of your SQL database, for example: abc123.database.windows.net.
  6. Choose the public cloud provider and region for the Satori Data Access Controller.
  7. Click Create. You will be redirected to the Data Stores list.

Connect to SQL Server Database via Satori

To connect to an SQL Server database using Satori use the Satori hostname that was generated by the management console which can be found under Satori Hostname in the data store settings view, for example: abc123.us-east-1.a.s0.satoricyber.net.

Connecting with the JDBC driver

To connect with the JDBC driver, override or add the host parameter in the JDBC URL. For example:

jdbc:sqlserver://abc123.us-east-1.a.s0.satoricyber.net;user=MyUserName;password=*****;encrypt=true;trustServerCertificate=false;...

Note: unsecured connections are not supported (non-SSL driver option) Note: Satori support JDBC driver version 7.2 and higher, and you must ensure that you are using TLS version 1.2 and higher

Connecting with the sqlcmd Command Line Utility

Please use version 15 or higher of PSQL.

To connect to SQL Server using sqlcmd you must use the -N command line parameter to enable secured connection. For example: sqlcmd -S abc123-cluster-cajcpwqzmvbb.us-east-1.a.p0.satoricyber.net -N -U john -P <john's password> -d <database name>

Connecting with the ODBC Driver

To connect with the ODBC driver, override the server, database and password parameters in the ODBC URL. For example:

`DRIVER={ODBC Driver 17 for SQL Server};SERVER='+server+';DATABASE='+database+';UID='+username+';PWD='+ password + ';Encrypt=yes;TrustServerCertificate=no;``

Note: unsecured connections are not supported (non-SSL driver option)

Connecting with Azure Data Studio

To Connect with Azure Data Studio, select Create a Connection with Server and set the Satori url, e.g. abc123.us-east-1.a.s0.satoricyber.net and enter user name and password. Note: unsecured connections are not supported, to enable secure connectivity verify the following settings are applied: - advanced->security->Always Encrypted to Enabled - advanced->security->Encryption to true

Connecting with Microsoft SQL Server Management Studio

To Connect with Microsoft SQL Server Management Studio, select Connect to Database Engine from File Menu, and set Server name to the Satori url, e.g. abc123.us-east-1.a.s0.satoricyber.net Select Authentication as SQL Server Authentication and enter user name and password. Note: unsecured connections are not supported, to enable secure connectivity verify the following settings are applied: - Options->Connection->checkbox Encrypted connection