Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide > Using XML as a Data Source >
XML ODBC Example
This is an example of an XML ODBC data source in the Microsoft ADO persisted file format. Note that both the data and the schema could be contained inside the same document.
<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly' rs:CommandTimeout='30' rs:updatable='true'>
<s:AttributeType name='ShipperID' rs:number='1' rs:writeunknown='true' rs:basecatalog='Northwind' rs:basetable='Shippers'
rs:basecolumn='ShipperID'>
<s:datatype dt:type='i2' dt:maxLength='2' rs:precision='5' rs:fixedlength='true' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='CompanyName' rs:number='2' rs:writeunknown='true' rs:basecatalog='Northwind' rs:basetable='Shippers'
rs:basecolumn='CompanyName'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='40' rs:maybenull='false'/>
</s:AttributeType>
<s:AttributeType name='Phone' rs:number='3' rs:nullable='true' rs:writeunknown='true' rs:basecatalog='Northwind'
rs:basetable='Shippers' rs:basecolumn='Phone'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='24' rs:fixedlength='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema><rs:data>
<z:row ShipperID='1' CompanyName='Speedy Express' Phone='(503) 555-9831 '/>
<z:row ShipperID='2' CompanyName='United Package' Phone='(503) 555-3199 '/>
<z:row ShipperID='3' CompanyName='Federal Shipping' Phone='(503) 555-9931 '/>
</rs:data>
</xml>
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Server Administration Guide Published: 23 June 2003 |