OBIEE - XML Data Source

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

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

See call interface

Advertising

3 - Management

3.1 - Connection URL

  • 12C
VALUEOF(NQ_SESSION.SERVICEINSTANCEROOT)/data/
  • Local file
c:\obieeXml\

3.2 - 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>

4 - Documentation / Reference

Advertising