Research into Tableau has found that it offers a robust API for integration. The two applicable use cases are:
Obtain Tableau’s dashboard contents and embed them in any application. This could be really useful if we want to explore in the future the ability to have your Tableau generated graph’s embedded within the TetraScience dashboard.
Create an interface between TetraScience’s platform and the Tableau servers. This interface can be created in order to utilize the data processed and stored in TetraScience’s data lake. This can be leveraged to process and store the created graphs and any other analytics completed with Tableau back to the TetraScience platform. Thanks to our metadata tagging capabilities, this allows you to organize all of your data in one central location for easy access.
Tableau also offers the ability to integrate with many programming languages used for data science. For example, if your Bioinformatics team is performing any computational experiments with the data and want to integrate it with the Tableau dashboard, they will be able to do so. As mentioned before, the final analysis or report can be sent to the TetraScience platform for storage and organization.
Lastly, in regards to overlaying data from multiple sources for reporting purposes, there is this quick tutorial detailing how to accomplish this, as well as this quick video showing the ability to add labels inside the graphs created. The first step to do all of this is to build the interfaces between your data sources and Tableau. Once that is completed, the graphical analysis can be conducted.
Tableau offers some guidance for connecting to Amazon Athena here. We recommend you have this page open as a reference when you make the connection to Athena.
We will summarize these steps here and add TetraScience-specific information below:
If you haven't already, be sure to download Java and the JDBC driver. This driver is required for connection to Athena. Instructions on downloading and installing this driver are found here, in the Amazon Athena dropdown.
To find AWS credentials and URLs, click on your profile tab on the top right corner, then click on the data tab on the left.
If you have not already generated AWS credentials, click the button to generate them.
When you generate your AWS password, be sure to record it. Otherwise, you will need to replace it in the future.
To see all of the necessary information, you will need to click "Show additional connection parameters." The 4 pieces of information you need from this page are:
- AWS username
- AWS password
- URL: This section contains your AWS server region (for example us-east-2 in this URL). The URL you need to use for Tableau is
athena.<AWS-region>.amazonaws.com. In the example above, this URL would be athena.us-east-2.amazonaws.com
- S3 output URL
Now open Tableau, click "Connections" and select "Amazon Athena". You will be prompted to enter the following information:
S3 Staging Directory: the S3 output URL
Access Key ID: Your AWS username
Secret Access Key: Your AWS password
When connecting Tableau to Amazon Athena, which server location is used?
You can find the server and S3 staging area info by:
- Logging in to the TS platform
- Accessing your account
- Clicking "Data" in the account menu
- Click "Show additional connection parameters" on the Data page.
When attempting to connect to Amazon Athena from Tableau, I encounter the following error. How can I fix this?
An error occurred while communicating with Amazon Athena.
Bad Connection: Tableau could not connect to the data source.
This error can occur when the S3 staging location is not specified. Be sure that it is specified both in Tableau and on the Tetra Data Platform. To check if this information is specified on Tetra Data Platform, click your profile, then "Data," and you will find the information on your Amazon Athena connection under "SQL Access."
Updated over 1 year ago