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

Using XML ODBC

Using the XML ODBC database type, you can access XML data sources through an ODBC interface. The data types of the XML elements representing physical columns in physical tables are derived from the data types of the XML elements as defined in the XML schema. In the absence of a proper XML schema, the default data type of string is used. Data Type 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 data type 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. From the File menu, choose Import > from Database.
4. Follow the instructions in the dialog boxes to import the ODBC DSNs into the repository.

   CAUTION:  Make sure you select the Synonyms option in the Import dialog box.