SQL Server Stored Procedure

This data source is unique in behavior as it is a dynamic data source which will be repopulated every time a selection is made within the TARGIT application.

Name

Specify the name for the data source

Server

Enter the hostname of the SQL Server

Use Windows Authentication

Specifies that TARGIT Data Service will connect with the service credentials. If this box is unchecked you will be asked to enter credentials for SQL Server Standard Edition.

User name - Enter the username when using SQL Server standard authentication.
Password - Enter the username when using SQL Server standard authentication.

Database

Select the database where the stored procedure exists

Stored Procedure

Choose the stored procedure on the server
After choosing the stored procedure a list of parameter names will be shown. To configure this you will have to enter the correct parameters for the Stored procedure to run and return a data set for detection the return results.

Metadata

The metadata can be toggled from automatic to manual.
When manual is chosen you will have to add the returned columns by name and specifying the datatype.