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 ImpersonationInfo 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.