MS SQL Instance & Item setup
In this guide we will go through the process of setting up an instance to communicate with an MS SQL Database using the MS SQL Connector on your SIA Connect device
The MS SQL Connector is compatible with MS SQL and Azure SQL databases
Instance setup
When creating a new instance for your MS SQL database, you will need to fill out some fields to create the connection between SIA Connect and the database:
| Parameter | Description |
|---|---|
| Connector | The connector you wish to use to establish the connection Choose "MS SQL" here |
| Name | The name of the instance. This can be anything you want |
| Address | The IP-address of the MS SQL Server you are going to connect to The port is also specified here. Examples: Without port: 10.20.30.10 With port: 10.20.30.10,1433 Please note that the port can be anything, the above port is simply an example |
| Username | The username for an account that has access to the database |
| Password | The password corresponding to the username |
| Database | The name of the database you want to read from |
| Connection String | Connection String for the database Note: This parameter is not always needed |
Item setup
In your newly created MS SQL Instance you can create items to query the database. SIA Connect connects to the database as any other client, and will be able to execute any queries that the selected user is authorized to perform
| Parameter |
Description |
|---|---|
| Query default |
This is the query that the item will perform in either the given time interval, or when it is triggered by a mapping Example: select * from (table name) |
Delete
For more information on using queries in SIA Connect, please refer to this guide