== Basic Table Linking==

The following instructions show you how to link remote database tables into Virtuoso using an ODBC data source. The linking procedure pulls metadata definitions for the remote tables. It does not link actual data from those tables. %BR%

1. Access the Virtuoso admin interface in a Web browser. %BR%

<img src="%ATTACHURLPATH%/Link1.png" style="wikiautogen"/> %BR%

2. Click the Conductor link on the left-handside navigation bar. %BR%

<img src="%ATTACHURLPATH%/Link2.png" style="wikiautogen"/> %BR%

3. Login to the Conductor using your Virtuoso DBA username and password. Both fields default to "dba." %BR%

<img src="%ATTACHURLPATH%/Link3.png" style="wikiautogen"/> %BR%

4. Click the Database tab. %BR%

<img src="%ATTACHURLPATH%/Link4.png" style="wikiautogen"/> %BR%

5. Click the External Data Sources sub-tab. %BR%

<img src="%ATTACHURLPATH%/Link5.png" style="wikiautogen"/> %BR%

6. Click the Data Sources tab that appears under the External Data Sources header. %BR%

<img src="%ATTACHURLPATH%/Link7.png" style="wikiautogen"/> %BR%

7.  Locate your ODBC Data Source in the list of Data Sources. %BR%

<img src="%ATTACHURLPATH%/Link8.png" style="wikiautogen"/> %BR%

8. Click the Connect link associated with your Data Source. %BR%

<img src="%ATTACHURLPATH%/Link9.png" style="wikiautogen"/> %BR%

9. Provide login credentials for your ODBC Data Source. %BR%

<img src="%ATTACHURLPATH%/Link10.png" style="wikiautogen"/> %BR%

10. Click the Connect button. %BR%

 <img src="%ATTACHURLPATH%/Link11.png" style="wikiautogen"/>  %BR%

11. Click the Link Objects link associated with your DSN.  %BR%

<img src="%ATTACHURLPATH%/Link12.png" style="wikiautogen"/>  %BR%

12. Scroll throught the list of exposed tables and check the ones that you want to link into Virtuoso.  %BR%

<img src="%ATTACHURLPATH%/Link13.png" style="wikiautogen"/>  %BR%

13. Scroll to the bottom of the page and click the Link button.  %BR%

 <img src="%ATTACHURLPATH%/Link14.png" style="wikiautogen"/>  %BR%

14. You can use the two text boxes and Set To All button to set a custom catalog and schema.  %BR%


<img src="%ATTACHURLPATH%/Link15.png" style="wikiautogen"/>  %BR%
<img src="%ATTACHURLPATH%/Link15a.png" style="wikiautogen"/>  %BR%

15. You can also use the Edit under the Action header to set or alter primary keys.  %BR%

<img src="%ATTACHURLPATH%/Link16.png" style="wikiautogen"/> %BR%
<img src="%ATTACHURLPATH%/Link16a.png" style="wikiautogen"/>  %BR%

16. Click the Link button. %BR%

 <img src="%ATTACHURLPATH%/Link18.png" style="wikiautogen"/> %BR%

17. Your linked table should appear on the External Linked Data Objects tab.  %BR%

 <img src="%ATTACHURLPATH%/Link17.png" style="wikiautogen"/> %BR%

You may now expose the tables into the Virtuoso Virtoso database by establishing an ODBC, JDBC, OLE DB, or ADO.NET based connection to Virtuoso itself. Consult the following documentation for additional information:

[[http://wikis.openlinksw.com/dataspace/owiki/wiki/VirtuosoWikiWeb/VirtuosoDataAccessClients|Connect to Virtuoso (ODBC, JDBC, OLE DB, .NET)]]