Linking MySQL Database Objects (Tables, Views, and Stored Procedures) into Virtuoso

Steps

  1. Start the Virtuoso Web User Interface.



  2. Select the Conductor link in the left frame and login as the dba user.



  3. Select the Databases -> External Data Source -> Data Sources tab menu items.



  4. Select the Connect button for the mysqlma MySQL DSN.



  5. On succesful connection, select the Link Objects button to obtain a list of available tables.



  6. Select all the tables that are part of the mysql catalog.



  7. Ensure a primary key is assigned to all tables that are to be used in the EDM generation phase.



  8. Change the Catalog for each table to be mysql using the Set All button.

  9. Select the Link button to link the selected tables into Virtuoso.



  10. On completion of the Link process, the tables will be displayed in the External Linked Objects tab.


  11. The linked tables can be queried by clicking on the hyperlink in the Local Name column of the External Linked Objects tab above. This loads the Virtuoso Interactive SQL interface with the required SQL Select for retrieving the remote table data. We shall use the mysql.mysqlma.artist table to demonstrate this.



  12. Click the Execute button to run the query and retrieve the results from the remote table.



  13. The tables can also be viewed as part of the Virtuoso SQL Schema Objects under the mysql catalog name.


    .
    .
    .


The link process is now complete enabling the tables to be queried as if part of the Virtuoso Schema.

Related

CategoryDocumentation CategoryVirtuoso CategoryDotNET? CategoryEntityFrameworks? CategoryWebSite