Microsoft SQL Server
Microsoft SQL Server is an open-source column-oriented DBMS for online analytical processing that allows users to generate analytical reports using SQL queries in real-time.
Creating a Microsoft SQL Server connection
Use one of the following methods to make a connection:
Using an account
To create the connection you need:
- Access to your Microsoft SQL Server service.
- Define which database you wish to connect to.
Obtaining the credentials
Follow the Go Microsoft SQL Server Documentation to obtain your credentials.
Creating your connection
-
In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
-
Select the Microsoft SQL Server icon. A dialog box with name of the connection and connection methods appears.
-
(Optional) Edit the name of the connection. At a later stage you cannot edit the name.
-
Select Password & Username as the method to make the connection.
-
Fill in the parameters:
- Username of the user to use for authentication.
- Password of the user to use for authentication.
- The Hostname of the Microsoft SQL server, without a protocol. Can be an IP or a domain name, but must be accessible to your runner.
- The Port number of the server to connect to.
- Name of the Database you wish you operate on.
-
(Optional) Click Test Connection to test it.
-
Click Create connection. The new connection appears on the Connections page.
Using a data source name
Obtaining the credentials
An alternative type of authentication is a custom Data Source Name (DSN) for Blink.
View the Go Microsoft SQL Server Documentation on how to format the connection string.
Creating your connection
- In the Blink platform, navigate to the Connections page > Add connection. A New Connection dialog box opens displaying icons of external service providers available.
- Select the Microsoft SQL Server icon. A dialog box with name of the connection and connection methods appears.
- (Optional) Edit the name of the connection. At a later stage you cannot edit the name.
- Select DSN as the method to create the connection.
- Fill in the parameters:
- The full DSN string to use for connection
- (Optional) Click Test Connection to test it.
- Click Create connection. The new connection appears on the Connections page.