2.2.4.2.2.6 DataSource

The DataSource complex type represents a source of data for cubes, dimensions, and mining structures. The following complex types extend this type:

  • RelationalDataSource

  • OlapDataSource

       <xsd:complexType name="DataSource" abstract="true" >
         <xsd:all>
           <!--These elements are common to each MajorObject-->
           <xsd:element name="Name"  type="xsd:string" />
           <xsd:element name="ID"  type="xsd:string" minOccurs="0" />
           <xsd:element name="CreatedTimestamp" type="xsd:dateTime" minOccurs="0" />
           <xsd:element name="LastSchemaUpdate" type="xsd:dateTime" minOccurs="0" />
           <xsd:element name="Description" type="xsd:string" minOccurs="0" />
           <xsd:element name="Annotations"  minOccurs="0" >
             <xsd:complexType>
               <xsd:sequence>
                 <xsd:element name="Annotation" type="Annotation" minOccurs="0"
                              maxOccurs="unbounded" />
               </xsd:sequence>
             </xsd:complexType>
           </xsd:element>
           <!--Extended elements for DataSource object-->
           <xsd:element name="ManagedProvider" type="xsd:string" minOccurs="0"/>
           <xsd:element name="ConnectionString" type="xsd:string"/>
           <xsd:element name="ConnectionStringSecurity" minOccurs="0">
             <xsd:simpleType>
               <xsd:restriction base="xsd:string" >
                 <xsd:enumeration value="PasswordRemoved" />
                 <xsd:enumeration value="Unchanged" />
               </xsd:restriction>
             </xsd:simpleType>
           </xsd:element>
           <xsd:element name="ImpersonationInfo" type="ImpersonationInfo"
                        minOccurs="0" />
           <xsd:element name="Isolation" minOccurs="0">
             <xsd:simpleType>
               <xsd:restriction base="xsd:string" >
                 <xsd:enumeration value="ReadCommitted" />
                 <xsd:enumeration value="Snapshot" />
               </xsd:restriction>
             </xsd:simpleType>
           </xsd:element>
           <xsd:element name="MaxActiveConnections" type="xsd:integer"
                        minOccurs="0"/>
           <xsd:element name="Timeout" type="xsd:duration"  minOccurs="0" />
           <xsd:element name="DataSourcePermissions" minOccurs="0">
             <xsd:complexType>
               <xsd:sequence>
                 <xsd:element name="DataSourcePermission"  type="DataSourcePermission"
                              minOccurs="0" maxOccurs="unbounded"/>
               </xsd:sequence>
             </xsd:complexType>
           </xsd:element>
               <xsd:element ref="eng300:QueryImpersonationInfo" minOccurs="0" />
               <xsd:element ref="eng300:QueryHints" minOccurs="0" />
         </xsd:all>
       </xsd:complexType>
    

The following elements are defined in the namespace eng300:

   <xsd:element name="QueryImpersonationInfo" type="eng:ImpersonationInfo" />
   <xsd:element name="QueryHints" type="xsd:string" />

The following table describes the elements that are included in the XSD schema for DataSource. Those elements common to all major objects are described in section 2.2.4.2.2.1.

Element

Read-Only

Default value

Description

ManagedProvider

Empty

The managed provider name.

ConnectionString

[Required]

The connection string. The password can be stripped out, depending upon the setting of the ConnectionStringSecurity element.

ConnectionStringSecurity

Yes

"Unchanged"

An enumeration value that specifies whether the user's password is stripped from the data source connection string for security purposes. The enumeration values are as follows:

  • PasswordRemoved – The user’s password is stripped from the connection string.

  • Unchanged - The connection string text is unchanged.

ImpersonationInfo

Empty

The user credentials that are used to connect to a data source.

Isolation

"ReadCommitted"

An enumeration value that specifies the isolation level for reading data that was modified but not committed by another simultaneous transaction. The enumeration values are as follows:

  • ReadCommitted – ReadCommitted isolation is used.

  • Snapshot – Snapshot isolation is used.

MaxActiveConnections

10

The maximum number of concurrent connections to the data source.

A negative number means that there is no limit. A value of zero means the default limit.

Timeout

Server default.

An integer that specifies the time, in seconds, after which an attempt to retrieve data reports a timeout.

DataSourcePermissions

Empty

A collection of objects of type DataSourcePermission.

QueryImpersonationInfo

Empty

The user credentials that are used to connect to a data source in DirectQuery mode. If not in DirectQuery mode, the value is ignored. If not provided, the credentials are obtained from the Impersonation element, also in this table.

QueryHints

Empty

If provided, the query hint is appended to any query before the query is invoked in DirectQuery mode.

Show: