The following step-by guide will lead you through manually publishing ODBC- or JDBC-accessible RDBMS data in RDF Linked Data form, using the Conductor's HTML-based wizard:

  1. Go to http://<cname>:port/conductor

  2. Log in as user dba (or another user with DBA privileges)

  3. Follow menu path Linked Data -> Views

    Figure 16.55. Linked Data Views

    Linked Data Views

  4. In the form presented, perform the following steps:

    1. Select the Database Name Qualifier (e.g., "Demo") that exposes the Tables / Views for this exercise

    2. Enter the Base URL to which your URL rewrite rules will be bound (e.g. http://<cname>:8890/Demo)

    3. Select specific Tables containing the data to be published (e.g., Demo.demo.Orders and Demo.demo.Products)

    4. Click the "Generate via Wizard" button

      Figure 16.56. Generate via Wizard

      Generate via Wizard

  5. At this point, you are presented with the option to edit your column selection. Select the "Edit" link, for example, for table Demo.demo.Products.

    Figure 16.57. Column Selection

    Column Selection

  6. For images or other binary data in MIME formats to be revealed as anything other than generic "binary objects", you must map large varbinary types to the appropriate MIME types like image/gif. To do so, select the Edit link for Binding/MIME Type of the relevant table columns. You can:

    1. Leave the Binding/MIME Type literal; or

    2. Set to skip, such that the column will not be used in RDF generation; or

    3. Select the binary object value in order for the column to be referenced as binary.

    Figure 16.58. Binding/MIME Types

    Binding/MIME Types

  7. After finishing with your changes click the Save button, or cancel the changes and go back by clicking the Cancel button.

  8. Make sure you click the "Next" button.

  9. At this point, the Linked Data View Definition form will let you Select Generation Targets options:

    1. Data Source Ontology Mappings

    2. Instance Data View Mappings

    3. VoID statistic

    Figure 16.59. Generation Targets options

    Generation Targets options

  10. Make sure you click the "Next" button.

  11. Based on your selections in the prior form, the Linked Data View Definition Deployment Options form will be offered:

    1. Data Source Ontology Rules

    2. Instance Data Rules

    Figure 16.60. Generation Targets options

    Generation Targets options

  12. Select the desired option(s) and click the "Prepare to Execute" button which unveils a generated Instance Data and/or Ontology form.

    Figure 16.61. Instance Data and/or Ontology

    Instance Data and/or Ontology

  13. Click the Execute button and Virtuoso will:

    1. Apply the generated declarations (instance data and ontology) to your Virtuoso instance

    2. Publish / Deploy declarations that expose the Wizard-generated Rewrite Rules and associated endpoints.

      Figure 16.62. Publishing / Deployment declarations

      Publishing / Deployment declarations

  14. Optionally, you can also perform one of the following tasks:

    1. Save Data Mappings: when clicked, offers to save the generated Definitions to local file system

    2. Save Ontology Mappings: when clicked, offers to save the generated Ontology to local file system

    3. Export as WebDAV resource: exports the selected objects/items as a WebDAV resource:

      1. Click "Browse"

      2. Enter a WebDAV resource and click the "Select" button.

      Figure 16.63. WebDAV resource

      WebDAV resource

    Note, the WebDAV resource path value will be shown in the WebDAV location field.

  15. Then click the "Save Data Mappings" or "Save Ontology Mappings" button, to complete the option task of saving your generated (or edited) view declarations.

    Figure 16.64. WebDAV resource

    WebDAV resource

  16. Error messages will be presented if the Wizard encounters problems. If there are no error messages, your Linked Data View declarations and Linked Data publishing activities will have completed successfully.

    Figure 16.65. Linked Data View declarations and Linked Data publishing activities Finish

    Linked Data View declarations and Linked Data publishing activities Finish

  17. Click on Cancel to return to the initial Linked Data View Generation form.