[OBIEE 11g] Adding an XML Data Source in OBIEE 11g

 

www.sssbi.com

Adding an XML Data Source in OBIEE 11g

This is a simple example file named XML_Example.xml. Here is the structure:

Next, create a new database in the physical layer. Set the Database as XML.

We need a Connection Pool. Set the ‘Data Source Name’ as the path to the directory on the server where the XML file is found.

Create a table with the name of the XML file (minus the file extension).

The columns within the table can be called whatever you want. What is important is the XPath declaration which describes how to find the column within the XML tree structure.

We are left with this structure in the physical layer:

Let’s try it out. We can use SELECT_PHYSICAL to query the repository physical layer directly from Administration > Issue SQL. E.g.

select_physical “TOTAL-BI” from “An XML Example”.”XML_Example”;

the data is retrieved from the XML file.