Contains one row for each Analysis Services OLAP/UDM data source that has been configured for they system.
Fields
| Field |
Field Type |
Null |
Notes |
Description |
|
SOURCENAME
|
nvarchar(255)
|
false
|
|
A friendly name to present to the end user when choosing a datasource
|
|
SOURCEDESCRIPTION
|
nvarchar(2048)
|
false
|
|
A description of this data source
|
|
MARTKEY
|
nvarchar(255)
|
false
|
|
The Mart key from the Mart Manifest file that generated this row
|
|
CONNECTIONSTRING
|
nvarchar(2048)
|
false
|
|
|
|
IMPERSONATE
|
bit
|
false
|
|
1 if a user should be impersonated when connecting to this datasource
|
|
IMPERSONATEUSERACCOUNTSID
|
varbinary
|
true
|
|
|
|
IMPERSONATEUSERNAME
|
nvarchar(128) (Computed)
|
true
|
|
Computed name of the IMPERSONATEUSERACCOUNTSID column value
|
|
IMPERSONATEUSERPWD
|
nvarchar(4000)
|
false
|
|
|
|
IMPERSONATELOCALUSERNAME
|
nvarchar(255)
|
false
|
|
The name of a local user to impersonate for the connection.
|
|
UDMDEPLOYMENTMANIFEST
|
xml
|
true
|
|
The contents of the udm deployment manifest that created this datasource.
|
|
ETLSERVERNAME
|
nvarchar(128)
|
false
|
|
Name of SQL Server where the ETL SQL Agent job is configured.
|
|
ETLJOBNAME
|
nvarchar(255)
|
false
|
|
Name of SQL Server SQL Agent job that invokes the data mart refresh.
|
|
ETLJOBSTEPNAME
|
nvarchar(255)
|
false
|
|
Name of SQL Server SQL Agent job step that invokes the data mart refresh.
|
|
MARTMANIFEST
|
xml
|
false
|
|
The contents of the data mart deployment manifest that created this datasource.
|
|
ETLDATABASENAME
|
nvarchar(128)
|
false
|
|
Name of SQL Server database where the ETL control table and ETL reset procedure are located.
|
|
ISOLAP
|
bit
|
false
|
|
True if this data source has an OLAP cube. If false then the data source if just used for relational data.
|
|
OLAPCLIENT_HTTP_DATASOURCE_URL
|
UDT_WEBADDRESS
|
false
|
|
The url to use for OLAP clients (such as Excel) for access to the Analysis Services server via HTTP.
|
|
DATEADDED
|
datetime
|
false
|
|
Indicates the date this record was added.
|
|
DATECHANGED
|
datetime
|
false
|
|
Indicates the date this record was last changed.
|
|
TS
|
timestamp
|
false
|
|
Timestamp.
|
|
TSLONG
|
bigint (Computed)
|
true
|
|
Numeric representation of the timestamp.
|
|
INCLUDESELECTIONS
|
bit
|
false
|
|
|
|
VALIDATIONPROCESSID
|
uniqueidentifier
|
true
|
|
|
|
ETLMAXPARALLELISM
|
int
|
false
|
|
|
|
DATEQUERYNAME
|
nvarchar(128)
|
false
|
|
|
|
DATEQUERYKEYCOLUMN
|
nvarchar(128)
|
false
|
|
|
|
SUPPORTSROLLINGDATES
|
bit
|
false
|
|
|
|
DATAWINDOWREFERENCE
|
datetime
|
true
|
|
|
