DISCOVER_DATASOURCES Rowset

Returns a list of the XML for Analysis (XMLA) provider data sources that are available on the server or Web service. The published data sources are returned from a URL of the application Web server. The client can connect to one of the data sources in this list.

If you call the Discover method with the DISCOVER_DATASOURCES enumeration value in the RequestType element, the Discover method returns the DISCOVER_DATASOURCES rowset.

Applies to: tabular models, multidimensional models

Rowset Columns

The client selects a data source by setting the DataSourceInfo property in the Properties element that is sent along with the Command element by the Execute method. A client should not construct the contents of the DataSourceInfo property to send to the server. Instead, the client should use the Discover method to find the data sources that the provider supports. The client then sends back the same value for the DataSourceInfo property that it gets from the DISCOVER_DATASOURCES rowset.

The DISCOVER_DATASOURCES rowset contains the following columns.

Column name

Type indicator

Restriction

Description

DataSourceName

DBTYPE_WSTR

Yes

The name of the data source, such as Adventure Works.

DataSourceDescription

DBTYPE_WSTR

The description of the data source entered by the publisher.

May return NULL.

URL

DBTYPE_WSTR

Yes

The unique path that shows where to invoke the XML for Analysis (XMLA) methods for that data source.

May return NULL.

DataSourceInfo

DBTYPE_WSTR

A string that contains any additional information required to connect to the data source.

May return NULL.

ProviderName

DBTYPE_WSTR

Yes

The name of the provider for the data source.

Example: "MSOLAP"

May return NULL.

ProviderType

DBTYPE_WSTR

Yes

The types of data supported by the provider. This array can include one or more of the following types:

MDP : multidimensional data provider.

TDP : tabular data provider.

DMP : data mining provider (implements the OLE for DB for Data Mining specification).

AuthenticationMode

DBTYPE_WSTR

Yes

A specification of what type of security mode the data source uses. Values can be one of the following:

Unauthenticated : No user ID or password has to be sent.

Authenticated : User ID and password must be included in the information required to connect to the data source.

Integrated : The data source uses the underlying security to determine authorization, such as Integrated Security provided by Microsoft Internet Information Services (IIS).

This schema rowset is not sorted.

Important

The DISCOVER_DATASOURCES rowset cannot be queried using DMV queries and the SELECT command syntax. However, the DISCOVER_DATASOURCES rowset can be queried using Microsoft.AnalysisServices.AdomdClient.AdomdConnection.GetSchemaDataSet

Using ADOMD.NET to return the rowset

When using ADOMD.NET and the schema rowset to retrieve metadata, you can use either the GUID or string to reference a schema rowset object in the GetSchemaDataSet method. For more information, see Working with Schema Rowsets in ADOMD.NET.

The following table provides the GUID and string values that identify this rowset.

Argument

Value

GUID

06c03d41-f66d-49f3-b1b8-987f7af4cf18

ADOMDNAME

DataSources

See Also

Reference

XML for Analysis Schema Rowsets