exasol / generic-virtual-schema Goto Github PK

View Code? Open in Web Editor NEW

0.0 9.0 1.0 50 KB

Limited capability Virtual Schema for generic JDBC data source

License: MIT License

Java 100.00%

virtual-schema generic jdbc exasol exasol-integration

generic-virtual-schema's Introduction

Deprecation Warning

**Attention: ** due to reduced user interest, we archived this repository.

Generic Virtual Schema

Overview

The Generic Virtual Schema provides an abstraction layer that makes an external JDBC data source accessible from an Exasol database through regular SQL commands. The contents of the external data source are mapped to virtual tables which look like and can be queried as any regular Exasol table.

This Generic Virtual Schema is limited to JDBC but generic in this domain, i.e. without specific capabilities.

It's important to notice that in order to set up a Virtual Schema for a specific data source system, the Virtual Schema implementation for that specific data source system (if any) should be used, and not the Generic Virtual Schema.

To see all available Virtual Schema implementations, please head over to the Virtual Schemas Repository.

Features

Access a data source in read-only mode from an Exasol database, using a Virtual Schema.

Information for Users

Find more documentation in the Virtual Schemas project.

Information for Developers

Virtual Schema API Documentation

generic-virtual-schema's People

Contributors

Watchers

Forkers

rohankumardubey

generic-virtual-schema's Issues

Update Generic dialect

Problem

Generic dialect needs to be updated with the latest vs-common-jdbc dependency.

Broken link checker fails

Add documentation

Update README.md to emphasize that this repo is limited to JDBC but in that domain generic, i.e. without specific capabilities.

Switch build to github actions

Problem

The badge of Travis build is broken.

Generic VS fails with Informix

Steps below:

Connection set up (redacted)
Verification of connection setup and pushdown query via import
Creation of container schema
Creation of adapter script in container schema
Creation of virtual schema against adapter (fail)

CREATE OR REPLACE CONNECTION INFORMIX
TO 'jdbc:informix-sqli://hostname:9088/dbname:INFORMIXSERVER=pronto_net'
USER 'username'
IDENTIFIED BY 'password';

IMPORT
FROM JDBC AT INFORMIX STATEMENT
'SELECT tabid, tabname, owner, nrows
FROM systables
WHERE owner = ''informix'' AND nrows > 1000
ORDER BY tabid';

tabid	tabname	owner	nrows

1|systables     |informix                        | 4062.0|
2|syscolumns    |informix                        |86164.0|
3|sysindices    |informix                        | 6088.0|
4|systabauth    |informix                        | 2062.0|
6|sysviews      |informix                        | 7101.0|
8|sysdepend     |informix                        | 1992.0|

11|sysconstraints|informix | 1990.0|
15|syscoldepend |informix | 1990.0|
17|sysprocbody |informix | 3768.0|
24|sysdistrib |informix | 8138.0|
25|sysfragments |informix | 5976.0|
26|sysobjstate |informix | 7966.0|
60|sysproccolumns|informix | 1726.0|

CREATE SCHEMA IFXTEST;

CREATE OR REPLACE JAVA ADAPTER SCRIPT IFXTEST.JAVA_ADAPTER AS
%scriptclass com.exasol.adapter.RequestDispatcher;
%jar /buckets/bucketfs1/drivers/virtual-schema-dist-8.0.0-generic-1.0.0.jar;
%jar /buckets/bucketfs1/drivers/ifxjdbc.jar;
/

CREATE VIRTUAL SCHEMA VS_IFXTEST
USING IFXTEST.JAVA_ADAPTER
WITH
SQL_DIALECT = 'GENERIC'
SCHEMA_NAME = 'pronto'
CONNECTION_NAME = 'INFORMIX';

SQL Error [22002]: VM error: F-UDF-CL-LIB-1126: F-UDF-CL-SL-JAVA-1006: F-UDF-CL-SL-JAVA-1026:
com.exasol.ExaUDFException: F-UDF-CL-SL-JAVA-1068: Exception during singleCall adapterCall
com.exasol.adapter.jdbc.RemoteMetadataReaderException: Unable to create remote metadata reader for the generic SQL dialect. Caused by: No suitable driver found for jdbc:informix-sqli://hostname:9088/dbname:INFORMIXSERVER=pronto_net