OBIEE - XML Data Source

About

Xml is a build-in drivers to be able to connect/read XML files in a specific format.

See OBIEE - Connection Pool

Articles Related

Management

Connection URL

12C

VALUEOF(NQ_SESSION.SERVICEINSTANCEROOT)/data/

Local file

c:\obieeXml\

File format

Example

<?xml version="1.0" encoding="UTF-8"?>
<Table Name="CON_DATA">
<CON_DATA>
<CON_NAME>15</CON_NAME>
<CON_DSN>1</CON_DSN>
<CON_USER>1</CON_USER>
<CON_PWD>1</CON_PWD>
</CON_DATA>
</Table>

or

<XML ID="12345">
    <test>
        <row>
            <field1>00</field1>
            <field2>01</field2>
        </row>
        <row>
            <field1>10</field1>
            <field2>11</field2>
        </row>
        <row>
            <field1>20</field1>
            <field2>21</field2>
        </row>
    </test>
</XML>

Documentation / Reference