Library Version 11.2.2.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:

    Select Data Source

    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 Metadata Types

    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:

    XSLT Management Page

    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