SQL Server

Allows connecting to Microsoft SQL Server data sources. If utilizing Windows Security on SQL Server the service account for the TARGIT Data Service must be changed to a user having access to the SQL Server tables.

Name

Enter the name of the data source

Server

Enter the name of the SQL Server you want to connect to.
Note: When using Windows Security the TARGIT Data Service account will be used for authentication.

Windows Authentication

By default, the connection is made using SQL Server authentication.

Uncheck the Box to use SQL Server authentication. Enter ’Username’ and ’Password’.

Database

Choose the database you want to retrieve data from

Table

Choose the table/view from the database that you want to use in a cube

SQL Command

Type a valid SQL command to retrieve data from the database. When making choices in Database and Table this field will be modified according to selections.

Schedule

Schedule how often you would like to refresh your data from this data source.