SQL Server

You can integrate with SQL Server in a few steps.
Follow these steps:

• Create a read-only login and the associated user
• Grant it the permissions required for Sifflet to operate
• Connect to Sifflet

1- Create a login and the associated user

To create the login, you will need to run the following SQL query.

CREATE LOGIN sifflet_login WITH PASSWORD = '<password>';  --replace with a password

To create the user associated to the login, you will need to run the following SQL query.
Please choose a "username" (for instance, sifflet_read_only_user).

Store the username and the password carefully as you will need them to connect to Sifflet later.

USE <database>; -- to replace
CREATE USER sifflet_read_only_user FOR LOGIN sifflet_login;

2- Grant the permissions

You can now assign the permissions to the newly created user (sifflet_read_only_user in the example above).

-- Grant the user access to the database schema
GRANT VIEW DEFINITION ON SCHEMA :: <schema> TO sifflet_read_only_user;
GRANT SELECT ON SCHEMA :: <schema> TO sifflet_read_only_user;

3- Connect to Sifflet

Create the Secret

• In "Integration" --> submenu "Secrets", create a new secret
• In the "Secret" area, copy-paste the username and password that you previously saved in step 1

{
  "user": "sifflet_login",
  "password": "password"
}

Add the datasource

On the left panel, choose "Integration" and then the "Sources" submenu

• Click "New" Datasource and choose "Mssql"

• Information required:

  • Name: the Sifflet name of the datasource
  • Host: the host of your SQL Server instance
  • Port: the port of your SQL Server instance
  • Connect using SSL or not: Sifflet currently accepts certificates from all certificate authorities
  • Database: the database you want to connect to
  • Schema: the schema you want to connect to
  • Secret: the secret you just created in the previous step