Connecting to files in S3 buckets via Amazon Athena

Comments

7 comments

  • Official comment
    Avatar
    Katie Garrison (Edited )

    Just tested on Sisense Version 7.2.1 and 7.3 - if you are using Sisense Web (ECM 2.0), you do not necessarily need to use the additional driver Jay wrote to connect to Athena AWS. Instead follow the instructions below. This is all based on the Generic JDBC connector instructions in the official documentation https://documentation.sisense.com/latest/managing-data/connectors/jdbc.htm:

    1. Download the Athena AWS JDBC Driver here: https://docs.aws.amazon.com/athena/latest/ug/connect-with-jdbc.html. In my test I used AthenaJDBC42-2.0.6.jar
    2. Create a folder called Athena in ..\ProgramData\Sisense\DataConnectors\jdbcdrivers\ 
    3. Place the .jar file in the Athena folder
    4. Restart the Sisense.JVMConnectorsContainer service
    5. Edit your Elasticube in Sisense web, add data using the Generic JDBC connector
    6. Use the following settings:
      Connection String: <your connection string>
      JDBC JARs Folder: C:\ProgramData\Sisense\DataConnectors\jdbcdrivers\Athena
      Driver's Class Name: com.simba.athena.jdbc.Driver
      User Name: <User name of the database>
      Password: <Password for that user>
    7. Then click Next to move on to table selection
    Comment actions Permalink
  • Avatar
    David Peterson (Edited )

    Does Sisense need the Java 8 or Java 7 jar file from Amazon?  Java does not seem to be installed on the Sisense box so difficult to say.  This page:  https://support.sisense.com/hc/en-us/community/posts/115000994027-Connecting-to-Data-using-a-JDBC-Driver?  references Athena driver 1.1 which is no longer available from AWS. I guess that was Java 6 maybe?  Only 2.0.2 for Java 7 and Java 8 jars are available.

    0
    Comment actions Permalink
  • Avatar
    Jay Dastur

    Sisense is packaged with a JRE 8   C:\Program Files\Sisense\Infra\jre

    So it should be backwards compatible with Java7

    0
    Comment actions Permalink
  • Avatar
    David Peterson (Edited )

    Thanks. I've been able to import tables into Sisense elasticube.  However, I just created a view in Athena but it does not appear in the Sisense JDBC import selector.  Just the tables in the list.

    0
    Comment actions Permalink
  • Avatar
    David Peterson

    Using SQL workbenchJ I can certainly see the view using:

     

    show views in "database_name";

    0
    Comment actions Permalink
  • Avatar
    Jay Dastur

    Hi David

    Are you using the same credentials ? The driver should load all object types. What is the name of the view ?

    There is an option to add a config file where you can manually specify any SQL. Can you open a support tickets and we can work via that channel

     

    0
    Comment actions Permalink
  • Avatar
    David Peterson (Edited )

    Yes using the same credentials.  I was adding tables and expected to add the view at the same time, but it was missing.  The name is normal ascii characters with only the underscore as a special character 

    0
    Comment actions Permalink

Please sign in to leave a comment.