Siebel Analytics Server Administration Guide > Using XML as a Data Source >

Using XML ODBC

Using the XML ODBC database type, you can access XML data sources through an ODBC interface. The datatypes of the XML elements representing physical columns in physical tables are derived from the datatypes of the XML elements as defined in the XML schema. In the absence of a proper XML schema, the default datatype of string is used. Datatype settings in the Physical layer will not override those defined in the XML data sources. When accessing XML data without XML schema, use the CAST operator to perform datatype conversions in the Business Model and Mapping layer of the Administration Tool.

To import XML data using ODBC

  1. To access XML data sources through ODBC, you need to license and install an XML ODBC driver.
  2. Next, create ODBC DSNs that point to the XML data sources you want to access, making sure you select the XML ODBC database type.
  3. Import the ODBC DSNs into the repository, making sure you select the Synonyms option in the Import dialog box, and then click OK.

 Siebel Analytics Server Administration Guide 
 Published: 23 June 2003