Polypheny to ODBC adapter

[FactEngineCommunity]

Affected Areas

DB, UI, Client

Feature Description

It would be good to have a general purpose ODBC Adapter such that Polypheny can hook up to any ODBC enabled database.

E.g. Rather than necessarily having a SQL Server, for instance, Adapter...a general purpose ODBC Adapter could set up a data Source in Polypheny to any ODBC compatible database.

This would allow Polypheny to have speed to market and role-out for new customers who have a need to connect to a database for which there is no dedicated Polypheny Adapter yet.

So, for instance, if I had an ORACLE database and there was no ORACLE Adapter for Polypheny yet, I could simply create an ODBC Data Source, and connect to that via the general purpose ODBC Adapter in Polypheny.

Use Case(s)

If I had an ORACLE database and there was no ORACLE Adapter for Polypheny yet, I could simply create an ODBC Data Source, and connect to that via the general purpose ODBC Adapter in Polypheny.

Possible Solutions

Create a general purpose ODBC Adapter for Polypheny such that a data Source can be created to connect to any ODBC Data Source (DSN)

Possible Alternatives

I see no alternative to this other than to have an adapter for each and every database on the market, and there are hundreds of relational databases, for instance. This way, Polypheny can connect to any ODBC compatible database.