Sisense (JDBC)
Interact Advanced Analytics uses the AWS Data Lake technologies to power the data querying, analysis, and retrieval. To connect Sisense to Interact's Advanced Analytics Solution, you will need:
- Sisense
- AWS Athena JDBC Driver
The setup largely mimics the steps outlined in the JDBC Connectivity page, as this covers the in-depth JDBC configuration steps.
The Sisense AWS Athena setup is documented in quite a lot of detail on this page.
https://documentation.sisense.com/latest/managing-data/connectors/athena.htm#gsc.tab=0
The only thing which is not covered in the Sisense AWS Athena documentation is setting the Workgroup setting which is a requirement for Interact Advanced Analytics. This is an Additional Configuration setting.
Full documentation on the AWS Athena JDBC Configuration can be found here (including the Workgroup setting.)
https://s3.amazonaws.com/athena-downloads/drivers/JDBC/SimbaAthenaJDBC-2.0.16.1000/docs/Simba+Athena+JDBC+Driver+Install+and+Configuration+Guide.pdf
Workgroup specifically can be found on page 104.
Ports
It is worth noting that whilst port 443 is used for communicating with the Data Lake, port 444 is used to stream query results back from the Data Lake to the BI tool, so both ports need to be open.
Updated 7 days ago