Can I create a database link from Oracle 18c to a JDBC data source with just the proper JAR file?

Question

I have an Oracle 18c database. From this DB I need to create a database link to a Progress/Openedge 11.7 database to retrieve some data.

I am somewhat familiar with Heterogeneous Services which uses ODBC drivers to connect to other data sources. But at present all I have is the JDBC driver openedge.jar. I am able to use this jar file to connect to the Openedge DB from DBeaver without a problem.

Is it possible to create a DBLink using this JAR file?

Answer 1

You can't create a database link.

You can, most likely, load the JAR file in the database and then create Java stored procedures that make connections to the remote database, issue queries, etc. That's not going to allow you to write queries that join arbitrary local and remote tables together but you could build that infrastructure. For example, you could build pipelined table functions that call Java stored procedures to fetch data from a remote database and then use those pipelined table functions in arbitrary queries that join to local tables.