Tableau

Web Data Connector

Cinchy exposes a Tableau Web Data Connector that provides access to Cinchy Saved Queries as data sources in Tableau. Tableau versions 2019.2+ are supported.
An active internet connection is required in order to use the Web Data Connector.

Pre-requisites

To get started, you must add a record into the Integrated Clients table in the Cinchy domain with the below values.
Column
Value
Client Id
tableau-connector
Client Name
Tableau
Grant Type
Implicit
Permitted Login Redirect URLs
Permitted Logout Redirect URLs
Permitted Scopes
Id, OpenId, Email, Profile, Roles
Access Token Lifetime (seconds)
3600
Show Cinchy Login Screen
Checked
Enabled
Checked

Connecting From Tableau

  1. 1.
    Launch Tableau
  2. 2.
    Under Connect -> To a Server select the Web Data Connector option
  3. 3.
    Enter the URL from the Permitted Login Redirect URLs field on the Integrated Clients record created under the Pre-requisites section above
  4. 4.
    The Cinchy login screen will appear, enter your credentials
  5. 5.
    Select one or more queries to add to your data set. The result of each query will be available as a Table in Tableau. If a query has parameters, you will be prompted to provide the parameter values before you can add it to your collection.
  6. 6.
    Click the Load button
The Cinchy query results will now be accessible for you to create your visualization.