2.2.5.2 DataSource Object

The DataSource object represents an external source of data. It is a child of a Model object.

The DataSource object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

ModelID

unsignedLong

An ID-based reference to a Model object.

Name

string

The name of the object.

Description

string

The description of the object.

Type

enumeration

The type of DataSource. The only possible values are as follows:

  • Provider (1) - A data source that has a data provider and connection string.

  • Structured (2) - A data source that uses a JSON-based extensible protocol to define the location and mechanism by which the data is retrieved. Compatibility level 1400 or higher is required.<16>

ConnectionString

string

A string that is used to open the connection to a provider data source.

ImpersonationMode

enumeration

A numeric value that specifies the credentials to use for impersonation when connecting to a provider data source. The enumeration values are as follows:

  • Default (1) – The server uses the inherited value of ImpersonationMode from the database object’s DataSourceImpersonationInfo (see [MS-SSAS] section 2.2.4.2.2.5).

  • ImpersonateAccount (2) - The server uses the specified user account.

  • ImpersonateAnonymous (3) - The server uses the anonymous user account.

  • ImpersonateCurrentUser (4) - The server uses the user account that the client is connecting as.

  • ImpersonateServiceAccount (5) - The server uses the user account that the server is running as.

  • ImpersonateUnattendedAccount (6) – The server uses an unattended user account.<17>

Account

string

The user account that is used for impersonation when connecting to a provider data source.<18>

Password

string

The password that is used to impersonate the specified user account when connecting to a provider data source.

MaxConnections

int

The maximum number of connections to be opened concurrently to the data source.

Isolation

enumeration

The kind of isolation that is used when executing commands against the provider data source. The possible values are as follows:

  • ReadCommitted (1) – This value specifies that statements cannot read data that has been modified, but not committed, by other transactions.

  • Snapshot (2) – This value ensures that the data read by any statement in a transaction is transactionally consistent, as if the statements in a transaction receive a snapshot of the committed data as it existed at the start of the transaction.<19>

Timeout

int

The timeout in seconds for commands executed against a provider data source.

Provider

string

An optional string that identifies the name of the managed data provider for the provider data source.

ModifiedTime

dateTime

The time that the object was last modified.

ConnectionDetails<20>

string

The information that identifies the location of the structured data source. This is a property bag formatted as a JSON string that allows details about the connection to the data source to be passed.

Compatibility level 1400 or higher is required.

Options<21>

string

The information that defines possible additional settings for the structured data source. This is a property bag formatted as a JSON string.

Compatibility level 1400 or higher is required.

Credential<22>

string

The credential information that authenticates against the structured data source. This is a property bag formatted as a JSON string.

Compatibility level 1400 or higher is required.

ContextExpression<23>

string

A string that can contain additional information, such as content type, content shape, and format, about the structure and/or metadata of the structured data source. The data source is then represented by the ConnectionDetails property.

Compatibility level 1400 or higher is required.