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.

Database

Choose the database you want to retrieve data from

Password

Enter password for connecting using standard security

Schedule

Decide how often you would like to schedule the data to refresh.

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.

Table

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

User Name

Enter user name for connecting using standard security

Windows Authentication

By default the connection is made using SQL Server authentication. Uncheck the box to use SQL Server authentication.