You can use an XML file to create a data source.
Do one of the following:
Place the XML file in a directory that your administrator has set up as a data source. For more information, see Setting Up a Connection to a File Data Source in Administrator's Guide for Oracle Business Intelligence Publisher.
Upload the XML file to the data model from a local directory.
Note:
To use BI Publisher's layout editor and interactive viewer, sample data from the XML file source must be saved to the data model.
Support of XML files as a data set type in BI Publisher follows certain guidelines.
The XML files that you use as input to the BI Publisherdata engine must be UTF-8 encoded.
Do not use the following characters in XML tag names: ~, !, #, $, %, ^, &, *, +, `, |, :, \", \\, <, >, ?, ,, /. If your data source file contains any of these characters, use the data model editor Structure tab to change the tag names to an acceptable one.
Use valid XML files. Oracle provides many utilities and methods for validating XML files.
There is no metadata available from XML file data sets, therefore grouping and linking are not supported.
Create data sets using XML files stored in file directories.
To create a data set using a XML file from a file directory data source:
You can create data sets using locally stored XML files.
To create a data set using a XML file stored locally:
You can refresh and delete uploaded local XML files.
After uploading the file, it is displayed on the Properties pane of the data model under the Attachments region, as shown below.
See Setting Data Model Properties for more information about the Properties pane.
To refresh the local file in the data model:
In the component pane, click Data Model to view the Properties page.
In the Attachment region of the page, locate the file in the Data Files list.
Click Refresh.
In the Upload dialog, browse for and upload the latest version of the file. The file must have the same name or it will not replace the older version.
Save the data model.
To delete the local file: