Attaching the Virtuoso Virtual Database Engine to ODBC- or JDBC-accessible Data Sources
Once the Virtuoso VDB Engine has been attached to an external data source, all objects (Tables, Views, Stored Procedures, etc.) accessible in that source may be exposed and addressed through a Virtual Schema in Virtuoso, as if they were local Virtuoso objects.
The general principles of this attachment are the same for all targets, but there are some known nuances to various targets. Source-specific articles covering these nuances are linked below.
Note: This feature is only available in the Commercial Editions (Personal, Enterprise, etc.) of Virtuoso.- DB2
- Firebird
- Informix
- Ingres
- MySQL
- Microsoft SQL Server
- Oracle
- PostgreSQL
- Progress/OpenEdge
- Sybase ASA/ASE
- Other JDBC-accessible sources, via ODBC-to-JDBC Bridge
- Other ODBC-accessible sources, via ODBC-to-ODBC Bridge