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.
Choose the database you want to retrieve data from
Enter password for connecting using standard security
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.
Choose the table/view from the database that you want to use in a cube
Enter user name for connecting using standard security
By default the connection is made using SQL Server authentication. Uncheck the box to use SQL Server authentication.