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.
Enter the name of the data source
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.
By default, the connection is made using SQL Server authentication.
Uncheck the Box to use SQL Server authentication. Enter ’Username’ and ’Password’.
Choose the database you want to retrieve data from
Choose the table/view from the database that you want to use in a cube
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.