Microsoft SQL server
MSSQL connectors are used to connect a Microsoft SQL server reports.
Connection string: The connection string to your SQL Database.
Connector Server Aliases: Used to fully inform NodeGraph of the different ways of referring to the data source.
Test: Performs a control of the connection string and verifies the ability to connect to SQL.
Add a MSSQL connector
| Field |
Default Input |
| SYSTEM ID |
Id |
| SYSTEM NAME |
Name |
| DESCRIPTION |
Description (optional) |
| CONNECTOR TAGS |
Tag1; Tag2; ... |
| CONNECTION STRING |
data source=localhost; initial catalog =AdventureWorks;Integrated Security=SSPI; |
| SERVER NAME |
mssql01-prod |
| FULLY QUALIFIED DOMAIN NAME |
mssql01-prod.company.com |
| IP |
123.456.789.123 |
| DNS NAME |
mssql01-prod.company.com;mssql02-prod.company.com; |