cancel
Showing results for 
Search instead for 
Did you mean: 

JDBC connector for live model

rahuldhomane
9 - Travel Pro
9 - Travel Pro

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 the same.

Do let us know the right way to connect with Athena using live model.

Thanks

1 REPLY 1

KatieG
Sisense Team Member
Sisense Team Member

Hi @rahuldhomane,

For your current connection to Athena in an Elasticube - are you using the Sisense Athena connector (yellow "Amazon Athena") or Generic JDBC (purple "Generic JDBC")? 

KatieG_2-1656007743312.png

If you are using the Sisense Athena connector, there is a way to enable live connection to Athena with a few steps. We do advise caution in that the performance of Live queries to Athena may not be as speedy as a connection to a high performance warehouse. So your mileage may vary here. 

These are the steps (for Sisense Linux only):

  1. Within Sisense, go to Admin tab > System Management > File Management 
    (if you're logged in as an Admin and don't see this menu, follow instructions at the end of this reply to enable)
    KatieG_3-1656008594419.png
  2. In File Management, navigate to connectors > framework > athena
  3. Double click the manifest.json file to open it it
  4. Find "supportLiveDataSource"
    Update its value to true
    KatieG_4-1656008749961.png
  5. Click the save icon at the top right corner
  6. Exit out of File Management
  7. Within Admin tab > System Management > click "Configuration"
    KatieG_5-1656008870069.png
  8. Scroll down to the bottom of the page - click "Manage Connectors" 
    KatieG_6-1656008920053.png
  9. Click "Athena"
  10. Scroll down to "enableAnalyticalEngine.value" and toggle this on
    KatieG_7-1656008993766.png

     

  11. Click "Save Changes"
  12. Now Athena should be enabled for Live and it should come up as an option when you create a new Live model

___________________________________

How to enable File Management:

  1. In Admin tab > System Management, click the Configuration button
     
    KatieG_1-1656011836209.png
  2. Click on the Sisense logo 5+ times to reveal additional menu options
    KatieG_2-1656011865248.png
  3. Click on ‘Base Configuration’
    KatieG_3-1656011889074.png
  4.  Scroll down the ‘File Management’ and expand the menu item.
    Toggle on fileManagement.enabled
    KatieG_4-1656011925182.png
  5. Click Save Base at the top right hand side of the page
    KatieG_5-1656011944521.png

     

  6. Then the File Management icon should show up

___________________________________

Hope that helps,

Katie G | Sisense Pre-Sales Solutions Architect