Issue while connecting Airpal to presto DB query engine

[surendraGaddam99]

Hi ,

Need help /suggestions on how to connect Airpal to Presto DB query engine .
As per my analysis i found below 2 ways.

1. Connect using Presto JDBC
   Class.forName("com.facebook.presto.jdbc.PrestoDriver");
   config.getDataSourceFactory().setUrl("jdbc:presto:linadv360pt3:8080/oracle/AF360ST1");
   config.getDataSourceFactory().setDriverClass("com.facebook.presto.jdbc.PrestoDriver");
   config.getDataSourceFactory().setPassword(password);

   Reference.yml file prestoCatalog :oracle

Not sure whether presto server required here .

2. Using Presto Server setup
   catalog files setup as shown
   ./presto-server-0.77/etc/catalog/oracle.properties
   ./presto-server-0.77/etc/catalog/mysql.properties

In this case we can set only one schema details in oracle.properties file
how to dynamically set other schema details.

My confusion is whether we need to use any one of the them or both the ways.
In my case i have multiple tenants with multiple schemas access.Need to configure schema access for them dynamically for Airpal to prestodb.

Like : Tenant Client 1 : Admin ,FIN ,HRM ,PB (schemas)
Tenant Client 2 : Admin ,FIN,HRM ,PB (schemas)

Please guide me .

Thanks
Surendra