<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="3. Quick Start & Tours" />
<meta name="dc.subject" content="3. Quick Start & Tours" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="quicktours.html" title="Chapter Contents" />
<link rel="prev" href="qsclientcon.html" title="Client Connections" />
<link rel="next" href="qswebserver.html" title="Web Server" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>3. Quick Start & Tours</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="qsvdbsrv" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>3. Quick Start & Tours</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="quicktours.html">Chapter Contents</a> | <a class="link" href="qsclientcon.html" title="Client Connections">Prev</a> | <a class="link" href="qswebserver.html" title="Web Server">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="quicktours.html">Quick Start & Tours</a>
</div>
<br />
<div>
<a href="newadminui.html">Where to Start</a>
</div>
<div>
<a href="qsclientcon.html">Client Connections</a>
</div>
<div class="selected">
<a href="qsvdbsrv.html">Virtual Database Server</a>
<div>
<a href="#confodbcdsn" title="Configuring Your ODBC Data Sources">Configuring Your ODBC Data Sources</a>
<a href="#dsnchk" title="Datasource Check">Datasource Check</a>
<a href="#demoquery" title="Demo Datasource Query">Demo Datasource Query</a>
<a href="#lnktabvirt" title="Linking Remote Tables Into Virtuoso">Linking Remote Tables Into Virtuoso</a>
<a href="#listunlnktabs" title="Listing or Unlinking Tables">Listing or Unlinking Tables</a>
<a href="#querybisql" title="Querying Linked Tables">Querying Linked Tables</a>
</div>
</div>
<div>
<a href="qswebserver.html">Web Server</a>
</div>
<div>
<a href="qswebdav.html">WebDAV</a>
</div>
<div>
<a href="qswebservices.html">Web Services</a>
</div>
<div>
<a href="qstexpwsmodules.html">Exposing Persistent Stored Modules as Web Services</a>
</div>
<div>
<a href="qsvsmx.html">VSMX - Virtuoso Service Module for XML</a>
</div>
<div>
<a href="qssqltoxml.html">SQL to XML</a>
</div>
<div>
<a href="qsnntp.html">NNTP</a>
</div>
<div>
<a href="vspquickstart.html">Dynamic Web Pages</a>
</div>
<div>
<a href="qsvspexamples.html">VSP Examples</a>
</div>
<div>
<a href="qshostingplugs.html">Third-Party Runtime Typing, Hosting & User Defined Types</a>
</div>
<div>
<a href="troutips.html">Troubleshooting Tips</a>
</div>
<br />
</div>
<div id="text">
<a name="qsvdbsrv" />
<h2>3.3. Virtual Database Server</h2>
<p>Virtuoso's Virtual Database Engine enables you to produce Dynamic Web Content from any
major database management system. This enables dynamic, real-time HTML and XML generation from
any number of different database engines concurrently. The
<a href="">Visual Server Administration Interface</a> of Virtuoso allows you to
effortlessly remotely choose and configure remote data sources to be linked into Virtuoso.
Once a table is linked into Virtuoso then it is usable like any native table leaving you free to
perform join queries without ever worrying about the underlying data source.
</p>
<p>The <a href="databaseadmsrv.html#vdbconcepts">Virtual Database (VDB) Engine</a> section of the
<a href="concepts.html">Conceptual Overview</a> chapter explains the concepts in more details.
</p>
<p>Visit the <a href="htmlconductorbar.html#remotetables">Visual Server Administration Interface</a> section
to see how to link tables into Virtuoso, or follow the small example below to get you started:
</p>
<a name="confodbcdsn" />
<h3>3.3.1. Configuring Your ODBC Data Sources</h3>
<p>Before you can link a table into Virtuoso, you need to configure an ODBC datasource. It is
quite likely that you already have ODBC data sources defined. If so, you can skip this part of the tour.
</p>
<p>If you do not have any data sources defined, you should configure your datasource using
an appropriate ODBC driver. The ODBC driver may come from the database vendor or a third-party
middleware vendor, such as OpenLink Software. You will need to configure your ODBC datasource in
accordance with the directions from your driver vendor.
</p>
<p>In this part of the tour, we show sample DSN configuration information for some database
vendor drivers. These examples of working data sources are not meant to replace the instructions
from the driver vendor. In your specific installation other parameters may be necessary.
</p>
<p>To define ODBC data sources on Windows XP/95/98/NT, in the Control Panel go to Administrative
Tools and then click the Data Sources (ODBC) icon.
</p>
<p>This first datasource uses OpenLink Generic ODBC Driver V6.0 to create DSN to a MySQL 5.x database.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="OpenLink Mutli Tier DSN Configuration with database MySQL 5.x" src="../images/virttour1.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.1. OpenLink Mutli Tier DSN Configuration with database MySQL 5.x</td>
</tr>
</table>
<p>The next example is an Informix 7 datasource using the driver from Informix Software, Inc.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Informix Driver DSN Configuration" src="../images/virttour2.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.2. Informix Driver DSN Configuration</td>
</tr>
</table>
<p>The next few images show a Microsoft SQL Server 6.5 datasource using the Microsoft Corporation
SQL Server driver.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="MS SQL Server DSN Configuration" src="../images/virttour3.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.3. MS SQL Server DSN Configuration</td>
</tr>
</table>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="MS SQL Server DSN Configuration" src="../images/virttour4.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.4. MS SQL Server DSN Configuration</td>
</tr>
</table>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="MS SQL Server DSN Configuration" src="../images/virttour5.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.5. MS SQL Server DSN Configuration</td>
</tr>
</table>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="MS SQL Server DSN Configuration" src="../images/virttour6.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.6. MS SQL Server DSN Configuration</td>
</tr>
</table>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="MS SQL Server DSN Configuration" src="../images/virttour7.gif" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.7. MS SQL Server DSN Configuration</td>
</tr>
</table>
<p>Finally, review the configuration information for your default local Virtuoso datasource,
named "<strong>Local Virtuoso</strong>".
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="OpenLink Virtuoso DSN Configuration" src="../images/virttour8.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.8. OpenLink Virtuoso DSN Configuration</td>
</tr>
</table>
<p>DSNs can be created and configured within the Virtuoso Conductor.
Go to "Database", then to "External Data Sources" and then go to "Configure Data Sources" tab. Click the "Add System DSN", or "Add User DSN", or "Add File DSN" button.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Creating a new DSN" src="../images/newdsn.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.1.9. Creating a new DSN</td>
</tr>
</table>
<br />
<a name="dsnchk" />
<h3>3.3.2. Datasource Check</h3>
<p>Before trying to link a table into Virtuoso, you should verify that the datasource is
working correctly. Use a tool such as Microsoft Access, or ODBCtest to test your datasource.
Your sanity check will verify that the datasource is correctly configured, that all necessary
software is installed, that the database is running, and that there are no permission related
problems. In addition, it will verify that the driver that you are using works correctly with
the underlying datasource.
</p>
<p> If there is a problem using a specific tool such as Microsoft Access with a specific driver,
then that same problem will be manifested when the datasource is exposed via Virtuoso.
</p>
<br />
<a name="demoquery" />
<h3>3.3.3. Demo Datasource Query</h3>
<p>To query the sample data in the Demo Database make sure the web browser is pointing to the
Demo database HTTP port which is typically 8890. From Conductor go to tab "Database" and then select
the tab "Interactive SQL". Enter a SQL statement and click the button "Execute". For example:
</p>
<div>
<pre class="programlisting">SELECT * FROM DEMO..products WHERE UnitPrice < 7</pre>
</div>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Demo Database Query" src="../images/demoquery.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.3.1. Demo Database Query</td>
</tr>
</table>
<br />
<a name="lnktabvirt" />
<h3>3.3.4. Linking Remote Tables Into Virtuoso</h3>
<p>A table on a remote datasource may be linked into the Virtuoso database so that it appears
as a local table. Start a browser and point to Conductor, for ex. http://localhost:8890/conductor/.
Go to tab "Database", then select "External Data Sources" and then "Sata Sources". Specify the remote datasource
that you wish to link to Virtuoso. For example, click the link "connect" for DSN "VirtuosoDemoTest".
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Enter login name and password." src="../images/conndsn1a.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.4.1. Enter login name and password.</td>
</tr>
</table>
<p>As result should be shown for DSN "VirtuosoDemoTest" the links "Link objects", "Change Credentials", "Disconnect". Click the "Link objects" link.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Connected to datasource." src="../images/conndsn1b.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.4.2. Connected to datasource.</td>
</tr>
</table>
<p>Pick the tables to be linked, and define the names to use.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Define tables to link" src="../images/rmtadd.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.4.3. Define tables to link</td>
</tr>
</table>
<br />
<a name="listunlnktabs" />
<h3>3.3.5. Listing or Unlinking Tables</h3>
<p>To list the tables that have been linked into Virtuoso, from Conductor go to
<strong>Databases/ External Data Sources/ External Linked Objects</strong>.
A table may be unlinked by pressing its "Unlink" icon.
</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="List of Connected Data Sources" src="../images/conndsn2.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.5.1. List of Connected Data Sources</td>
</tr>
</table>
<br />
<a name="querybisql" />
<h3>3.3.6. Querying Linked Tables</h3>
<p>Once the tables have been linked into Virtuoso, they can be queried using the Interactive
SQL query. From the Conductor UI go to <strong>Database/Interactive SQL</strong>. Type a SQL that accesses a remote
table such as: SELECT * FROM Demo.VirtuosoDemoTest.CustomersLinked. Click the "Execute" button.
</p>
<p>Press the Execute button and review the results.</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Remote Table Query" src="../images/rmtdsnqry.png" />
</td>
</tr>
<tr>
<td>Figure: 3.3.6.1. Remote Table Query</td>
</tr>
</table>
<br />
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="qsclientcon.html" title="Client Connections">Previous</a>
<br />Client Connections</td>
<td align="center" width="34%">
<a href="quicktours.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="qswebserver.html" title="Web Server">Next</a>
<br />Web Server</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
834
