Primary Key Field Type
 ID uniqueidentifier

Field Field Type Null Notes Description
 SOURCENAME nvarchar(255)   Default = '' A friendly name to present to the end user when choosing a datasource
 SOURCEDESCRIPTION nvarchar(2048)   Default = '' A description of this data source
 MARTKEY nvarchar(255)   Default = '' The Mart key from the Mart Manifest file that generated this row
 CONNECTIONSTRING nvarchar(2048)   Default = ''
 IMPERSONATE bit   Default = 0 1 if a user should be impersonated when connecting to this datasource
 IMPERSONATEUSERACCOUNTSID varbinary
 IMPERSONATEUSERNAME nvarchar(128) (Computed) SUSER_SNAME(IMPERSONATEUSERACCOUNTSID) Computed name of the IMPERSONATEUSERACCOUNTSID column value
 IMPERSONATEUSERPWD nvarchar(4000)   Default = ''
 IMPERSONATELOCALUSERNAME nvarchar(255)   Default = '' The name of a local user to impersonate for the connection.
 UDMDEPLOYMENTMANIFEST xml The contents of the udm deployment manifest that created this datasource.
 ETLSERVERNAME nvarchar(128)   Default = '' Name of SQL Server where the ETL SQL Agent job is configured.
 ETLJOBNAME nvarchar(255)   Default = '' Name of SQL Server SQL Agent job that invokes the data mart refresh.
 ETLJOBSTEPNAME nvarchar(255)   Default = '' Name of SQL Server SQL Agent job step that invokes the data mart refresh.
 MARTMANIFEST xml   The contents of the data mart deployment manifest that created this datasource.
 ETLDATABASENAME nvarchar(128)   Default = '' Name of SQL Server database where the ETL control table and ETL reset procedure are located.
 ISOLAP bit   Default = 0 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   Default = '' The url to use for OLAP clients (such as Excel) for access to the Analysis Services server via HTTP.
 DATEADDED datetime   Default = getdate() Indicates the date this record was added.
 DATECHANGED datetime   Default = getdate() Indicates the date this record was last changed.
 TS timestamp   Timestamp.
 TSLONG bigint (Computed) CONVERT(bigint, TS) Numeric representation of the timestamp.
 INCLUDESELECTIONS bit   Default = 0
 VALIDATIONPROCESSID uniqueidentifier
 ETLMAXPARALLELISM int   Default = 1

Foreign Key Field Type Null Notes Description
 OLAPDATASOURCECATEGORYCODEID uniqueidentifier OLAPDATASOURCECATEGORYCODE.ID FK to Olap Data Source Category Code table.
 BEFORE_ETL_QUEUEPROCESSID uniqueidentifier QUEUEPROCESS.ID The ID of a Queue business process to run before the Etl starts.
 AFTER_ETL_QUEUEPROCESSID uniqueidentifier QUEUEPROCESS.ID The ID of a Queue business process to run after the Etl ends.
 ADDEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.
 CHANGEDBYID uniqueidentifier   CHANGEAGENT.ID FK to CHANGEAGENT.

Index Name Field(s) Unique Primary Clustered
 IX_OLAPDATASOURCE_DATEADDED DATEADDED    
 IX_OLAPDATASOURCE_DATECHANGED DATECHANGED      
 PK_OLAPDATASOURCE ID  
 UC_OLAPDATASOURCE_SOURCENAME SOURCENAME    

Trigger Name Description
 TR_OLAPDATASOURCE_AUDIT_UPDATE
 TR_OLAPDATASOURCE_AUDIT_DELETE

Referenced by Field
 ETLHISTORY OLAPDATASOURCEID
 ETLREFRESHPROCESS OLAPDATASOURCEID
 OLAPDATASOURCEATTRIBUTECATEGORY OLAPDATASOURCEID
 OLAPDATASOURCESMARTFIELD OLAPDATASOURCEID
 OLAPDATASOURCEVALIDATIONPARAMETERS OLAPDATASOURCEID
 OLAPREFRESHPROCESS OLAPDATASOURCEID
 RE7ATTRIBUTEPROCESS OLAPDATASOURCEID

Entity-Relationship diagram of this table