3.1.4.2.2.1.3.33.1 Columns

The DISCOVER_DATASOURCES rowset contains the following columns.

Name

Type

Restriction

Description

DataSourceName

xsd:string

Yes

The name of the data source.

DataSourceDescription

xsd:string

The description of the data source.

URL

xsd:string

Yes

The unique path of the data source.

DataSourceInfo

xsd:string

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

ProviderName

xsd:string

Yes

The name of the provider for the data source.

ProviderType

xsd:string

Yes

This array specifies the types of data supported by the server. It 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).<300>

AuthenticationMode

xsd:string

Yes

A string that specifies 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.<301>

The rowset is not sorted.

The response has the following definition.

       <xsd:element name="root">
         <xsd:complexType>
           <xsd:sequence minOccurs="0" maxOccurs="unbounded">
             <xsd:element name="row" type="row" />
           </xsd:sequence>
         </xsd:complexType>
       </xsd:element>
       <xsd:complexType name="row">
         <xsd:sequence>
           <xsd:element sql:field="DataSourceName" name="DataSourceName" type="xsd:string" />
           <xsd:element sql:field="DataSourceDescription" name="DataSourceDescription" 
                            type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="URL" name="URL" type="xsd:string" minOccurs="0" />
           <xsd:element sql:field="DataSourceInfo" name="DataSourceInfo" type="xsd:string" 
                            minOccurs="0" />
           <xsd:element sql:field="ProviderName" name="ProviderName" type="xsd:string" />
           <xsd:element sql:field="ProviderType" name="ProviderType" type="xsd:string" 
                            minOccurs="0" maxOccurs="unbounded" />
           <xsd:element sql:field="AuthenticationMode" name="AuthenticationMode" 
                            type="xsd:string" minOccurs="0" />
         </xsd:sequence>
       </xsd:complexType>