Forum Discussion

rahuldhomane's avatar
rahuldhomane
ETL
06-22-2022

JDBC connector for live model

Hi,  We had established Athena connection using the JDBC connector present under elasticube model. We wanted to establish Athena connection using live model but could not find JDBC connector for th...
Data Connectors
rahuldhomane's avatar
rahuldhomane
ETL
06-27-2022

Hi KatieG ,

Thanks for the detailed clarification!

However we used the  Generic JDBC (purple "Generic JDBC") connector for our Elasticube connection. Also, we are running Sisense Version: L2021.8.0.99 on Chrome (Windows machines).

Do let us know if you need additional details from our end.

Thanks,

Rahul Dhomane 

KatieG's avatar
KatieG
Sisense Employee
06-30-2022

Hi rahuldhomane, 

Thanks for that info - based on my research, if you were to use the GenericJDBC live connection in Sisense you will need to do additional work yourself to create and configure a custom dialect for the driver. Creating a custom dialect may not be straightforward if you don't have experience with it.

Before considering that route, I recommend you try the method I outlined in the previous response with the Athena connector as you would not need to create and configure a dialect.

Hope that helps,