jdbcgemfireoql

How to access gemfire cache from jdbc driver


I have a gemfire cache v8.2.1 from which I want to access data using a third party tool which can only access data using jdbc driver only. Does anyone know how can I connect to gemfire cache for accessing data using jdbc? I don't require to write to cache, just want to read from the cache.

I came across with gemfirexd on internet but can see that its marked as "End of availability".

Is there any other way where persisted Objects can be retrieved or OQL can be fired but can mimic a jdbc driver so that the any tool that accepts only jdbc drivers can be used?

Please help. Thanks


Solution

  • Apache Calcite has a Geode adapter that enables you read data from GemFire over JDBC. There is also this video explaining this.