Library Version 12.1.3.0

Using SPARQL Gateway as an XML Data Source to OBIEE
Prev | Chapter 9. SPARQL Gateway for XML-based Tools | Next

## Using SPARQL Gateway as an XML Data Source to OBIEE

This section explains how to create an XML Data source for Oracle Business Intelligence Enterprise Edition (OBIEE), by integrating OBIEE with RDF using SPARQL Gateway as a bridge. (The specific steps and illustrations reflect the Oracle BI Administration Tool Version 11.1.1.3.0.100806.0408.000.)

1. Start the Oracle BI Administration Tool.

2. Click File, then Import Metadata. The first page of the Import Metadata wizard is displayed, as shown in the following figure:

   Connection Type: Select XML.

   URL: This is the URL required for an application to interact with SPARQL Gateway, as explained in Using SPARQL Gateway with RDF Data. You can also include the timeout and best effort options.

   Ignore the `User Name` and `Password` fields.

3. Click `Next`. The second page of the Import Metadata wizard is displayed, as shown in the following figure:

   Select the desired metadata types to be imported. Be sure that `Tables` is included in the selected types.

4. Click `Next`. The third page of the Import Metadata wizard is displayed, as shown in the following figure:

   In the Data Source View, expand the node that has the table icon, select the column names (mapped from projected variables defined in the SPARQL SELECT statement), and click the right-arrow (>) button to move the selected columns to the Repository View.

5. Click `Finish`.

6. Complete the remaining steps for the usual OBIEE Business Model work and Mapping and Presentation definition work, which are not specific to SPARQL Gateway or RDF data.

Prev | Up | Next
Using the SPARQL Gateway Graphical Web Interface | Home | Appendix A. Prerequisite Software