Hi, This is Gowtham. I am checking for options to come up with JDBC data adapter on top of REST API based data sources. We have common REST API end point and we have options to add tags like "filter", "group by" and so on to bring specific data using simple REST API calls. We have got recommendations from community that Calcite is feasible option for us where we can interact with SQL and we can configure parsing the SQL to REST API url based on the datasource specific language.
I have searched through Calcite site. But I am unable to find the good starting point. I did leverage one example provide using DataFactory with custom java objects to analyze using SQL. But we realized that, we need to build multiple such objects. As I am looking for dynamic REST API generation based on simple SQL query provided by user. Could you please suggest if there any sample data adapter example to be leveraged in this aspect? Please suggest. Best Regards Gowtham Sen Potnuru
