Connect Tableau to Tallyfy

How can I connect Tableau to my Tallyfy data?

This comprehensive guide demonstrates establishing connections between Tableau and Tallyfy process data through Amazon Athena integration, enabling sophisticated visualizations and reports based on your workflow information.

Tableau connection capabilities transform raw Tallyfy data into actionable business intelligence, facilitating advanced analytics, performance monitoring, and strategic decision-making through professional data visualization tools.

Requirements

Before beginning the connection process, ensure you have:

• Tallyfy Analytics subscription activated for your organization
• Tableau Desktop installed (version 10.0 or higher)
• Administrative access to your computer for driver installation
• Authentication credentials provided by Tallyfy Support

Authentication Overview

Amazon Athena (which hosts Tallyfy Analytics data) offers two authentication methods:

Method	Description	Best For
IAM Username/Password	Web console access credentials	AWS Console access only
Access Key/Secret	Token-based authentication	BI tool connections (recommended)

Important Note

When Tallyfy provisions your Analytics account, you will receive two distinct credential sets:

• AWS IAM login - Use only for accessing the AWS web console
• Access Key + Secret Access Key - Use for connecting Tableau and other BI tools

Token-based authentication (Access Key + Secret Access Key) is strongly recommended for Tableau connections as it provides more reliable access and avoids common authentication errors like “The security token included in the request is invalid.”

Setup Process

Step 1: Install Required Drivers

Before configuring Tableau, you must install:

1. Download and install 64-bit Java from Java’s official site ↗, following the on-screen prompts. This is required for the JDBC connection.
2. Download the Amazon Athena JDBC Driver from the AWS Athena JDBC documentation page ↗.
3. Install the downloaded driver in the appropriate Tableau driver directory: C:\\Program Files\\Tableau\\Drivers for Windows or ~/Library/Tableau/Drivers for macOS.

Driver Updates

Always refer to the latest AWS documentation for the most current driver versions and installation instructions, as these may change over time.

Step 2: Configure Tableau Connection

1. Launch Tableau Desktop.
2. Click Connect > To a Server > Amazon Athena.
3. In the connection dialog, enter the Server (athena.us-east-1.amazonaws.com or your specific region).
4. Enter the Port (443).
5. Enter the S3 Staging Directory provided by Tallyfy (e.g., s3://tallyfy-athena-results/).
6. Enter your Tallyfy-provided Access Key ID.
7. Enter your Tallyfy-provided Secret Access Key.
8. Enter the Region (us-east-1 or your specific region).
9. Click Sign In.

Step 3: Access Tallyfy Data

Once connected:

1. Select AwsDataCatalog from the Catalog dropdown
2. Select your assigned database (typically your organization name) from the Database dropdown
3. You will see available tables containing your process data
4. Drag tables into your workspace to begin analysis

Working with Tallyfy Data in Tableau

Available Data Tables

Tallyfy Analytics makes several core tables available:

• processes - Completed and in-progress workflow instances
• steps - Individual task data within processes
• form_fields - Form field values collected during workflows
• users - User activity and participation metrics

Creating Effective Visualizations

With your Tallyfy data connected, you can:

1. Create process duration visualizations to identify bottlenecks
2. Build user performance dashboards showing task completion metrics
3. Analyze form field data to extract valuable business insights
4. Establish real-time monitoring of active processes

Video Tutorial

The following video walks through the complete connection process:

Troubleshooting Connection Issues

If you encounter connection problems:

• Verify your Access Key and Secret Access Key are entered correctly
• Ensure the JDBC driver is installed in the correct location
• Check that your computer can access the athena.us-east-1.amazonaws.com endpoint
• Confirm your Tallyfy Analytics subscription is active
• Restart Tableau after installing or updating drivers

For persistent connection issues, contact Tallyfy Support with specific error messages.

Related articles

Analytics > Tableau

Tableau integration enhances Tallyfy Analytics by offering extensive data visualization tools for creating interactive dashboards and reports to analyze workflow performance through direct connectivity with Amazon Athena.

Powerbi > Connect Power BI

Microsoft Power BI connects to Tallyfy Analytics through Amazon Athena to enable advanced visualization and analysis of workflow data using token-based authentication and ODBC drivers for creating interactive dashboards.

Tableau > Troubleshoot issues

Setting up reliable Tableau connections to Tallyfy Analytics requires using Access Key authentication while following proper data connection protocols and implementing preventive maintenance steps to avoid disruptions.

Analytics > Power BI

Microsoft Power BI enables interactive data visualization and business intelligence by connecting to Tallyfy Analytics through Amazon Athena to create custom reports dashboards and performance tracking for workflow optimization.