Database Reference
In-Depth Information
Note
To see the impersonation information defined at the database level, right-
click on the project in the
Solution Explorer
window and select
Edit
Database
. This will allow you to edit Analysis Services' database-level
properties. You will find the
DataSourceImpersonationInfo
property
within the SSDT
Properties
window.
11. Once you click on the ellipsis button, you'll find that it has the same four op-
tions as the impersonation tab of each data source (the
Default
option is syn-
onymous with
Inherit
).
Note
If impersonation is set to
Default
at the database level and
Inherit
at
the data source level, the data source will use the Analysis Services ser-
vice account for connecting to the relational database. For example, if
you're using Windows' authentication to connect to a SQL Server rela-
tional source, you need to ensure that the account running the Analysis
Services service has necessary permissions to read data from SQL Serv-
er database objects.
12. The last screen of the wizard asks for a data source name. Be sure to supply
a descriptive name before you click on
Finish
so that you can easily differen-
tiate between multiple data sources. The newly defined data source will show
up in the
Data Sources
folder within SSDT.
How it works...
If you have worked with various relational database platforms, you would be aware
of the similarities; they all consist of tables, rows, and columns. But you might
also recall the differences, for example, the flavour of the SQL language used by
the SQL Server could be somewhat different from the one utilized by Oracle, Sy-
base, or Teradata. So you might wonder how SSAS knows which syntax works for
Search WWH ::
Custom Search