OBIEE: XML File as Data Source

Thanks to Chet Justice for this story

I received a question in the form of a comment on using XML files here. Fittingly, we were discussing this exact topic yesterday and I decided I would try it out.

So here goes.

You'll need 2 files: a XML file and a XSL stylesheet (which defines the XML file). I found said files here. I'll also provide them here (cdcatalog.xml) and here (cdcatalog.xls).

In the Administration tool, go to File --> Import --> from Database

file import from database

When you prompted to select a datasource, select XML and the window should look like this

XML blank

For URL, browse to the location you saved cdcatalog.xml, do the same for XSLT

XML Full

Hit OK and you'll be prompted with the Import dialog

Import Dialog

Import the "table" and you're done.

XML Table! FTW!



Read the entire article at its source

LATEST WHITEPAPERSWHITEPAPERS RSS

Whitepaper Search Results:

Whitepaper Search Results:

Whitepaper Search Results: