Configuration
Last updated
Last updated
Property | Description |
---|---|
Property | Description |
---|---|
Property | Description |
---|---|
Name
The name that will be visible when selecting a data source.
Use Variables?
Tick to use variables for the Server Instance, User Name, and Password settings, or enter them manually.
Server Instance
The address, either URL or the IP address, where the server can be accessed.
Use SQL Server Authentication
Some SQL credentials do not need a Password to be specified, while others do. Tick to enter a Password.
User Name
The username used to log into the SQL database.
Password
The password used to log into the SQL database. Applies if Use SQL Server Authentication is ticked.
Database
The database from which data is retrieved.
Specify SQL Query
Tick to return rows from a query; or leave unticked to return rows from a table (default).
SQL Query
The command to query data from the SQL database (applies when Specify SQL Query is ticked).
Primary Key
The column or attribute of the SQL Query used to identify rows in the result (applies when Specify SQL Query is ticked).