This data
source allows you to create a connection to SQL Server tables. You can
also create a connection to SQL Server views. You need to have at least read access
to the source before you can create a successful connection.
In this example, connect to the
RequestUsage table located in the WSS_Logging database.
1. | After you
create a new data source based on the SQL Server table data template,
the SQL Connection Settings screen appears.
|
2. | Next, specify the server, database, and table or view
name.
|
3. | You can
also choose to configure the connection string manually to get access to
all connection string properties, as you did with Analysis Services. As
with all other tabular data sources, the authentication options
available are Unattended Service Account and Per-user Identity. Figure 1
shows how the settings should look after you specify all the properties.
|
4. | As with
all tabular data sources, verify that all columns have been properly
configured as a dimension or fact. In addition, verify that all facts
are using the proper aggregation column (see Figure 2).
|
As shown in Figure 2,
all the columns except for the RowID are configured correctly. The
RowID is interpreted as a dimension since it contains GUID’s, so it has
been set to be a dimension.
After you change the RowID
column to be of type Key, the data source is ready to be used in a
scorecard.