Specify the name of the SQL Instance as defined in the Utils Extension SQL Server configuration. Using the Default SQL Instance setting will retrieve the current setting from the SQL Connection settings of the Utils extension.

NOTE: For more information, please see Connecting to Microsoft SQL Server data source article.

Specify database name from selected SQL Instance.

Specify SQL Table or View from the selected database. Click the [...] button to display a list of tables from which to choose.

Specify the database from the data source SQL Instance. Click the [...] button to enter SQL Credentials.

NOTE: Cayosoft Administrator does not support Windows Authentication for connecting to a Microsoft SQL Server database. The database connection must use SQL Server Authentication, where the credentials (username and password) are created and managed within SQL Server itself. Mixed Mode refers to the SQL Server configuration that allows both SQL Server Authentication and Windows Authentication, but only SQL Server Authentication is supported by Cayosoft Administrator.

You can use the point-and-click filter builder for the specified data source.

NOTE: If the Where clause is also specified, it will be applied and DataSource Filter will be ignored.

Specify the column to read the values from.

NOTE: If the column does not contain a string or anything that can be converted to a string (the like INT), then the following error will be displayed: Values in the selected column <Column name> cannot be converted to a string.

More options