Ascend integrates with Tableau through Ascend's Tableau Connector. You can now build Tableau workbooks that are directly linked to components in Ascend! The connector is available through the Tableau connector gallery. Here is how it's done.
To prepare the Tableau connection, first create a Service Account and generate an API Token in the Data Service you wish to pull data from. To provide access to any component in that Data Service, create the account with permission 'Read Only.' For narrower control over what data the Tableau user can see, create the account with permission 'Data Feed Read Only.' This will limit access to read data from only the Data Feeds in that Data Service. You will use these credentials in Tableau to connect to Ascend.
- Prerequisite: Tableau Desktop 2020.3 or later
- Download the Spark SQL Driver.
a) Go to Tableau's Driver Download website
b) Choose 'Spark SQL' for data source, and pick the appropriate operating system
c) Follow instructions on installing the Simba ODBC driver
- Download the Ascend Tableau connector
- Move the connector .taco file to:
a) macOS: ~/Documents/My Tableau Repository/Connectors
b) Windows: My Documents/My Tableau Repository/Connectors
c) Linux: My Tableau Repository/Connectors
- Restart Tableau
- On the Connect Screen, under 'To a Server', select 'More...'., then select 'Ascend ODBC by Ascend.io'
- For server, customize the following with your Ascend subdomain:
<your_subdomain_here>.sql.ascend.io. Keep the default port 10000.
- Enter your service account username and password.
At this point the connection appears in the Connection listing in Tableau. Since Service Accounts are credentialed to a specific Data Service, the Connection can only access the Ascend components in that Data Service. This way you can manage access to specific data for different users simply by managing the creation and distribution of credentials.
The Ascend Dataflows that are contained in the Data Service behind the Connection are available as 'Schemas', Each component in those Dataflows is available as a 'Table' in its 'Schema'. By default, due to the large number of schemas and tables available, we do not load the list immediately when the connection is made. Also, data engineers could be updating the components on the Ascend side, so the list of Schemas is refreshed each time you use this function.
Use the search function in the 'Schema' box to find the Dataflow you want to access. (Tip: an empty search will return the full list of schemas available.)
To add data sources from other Dataflows in Ascend, repeat the connection process. This way you can assemble reports and visualizations with data from across all of the data assets managed in Ascend. (Tip: Use the rename function in Tableau to label each Connection more descriptively, and avoid multiple connections to the same Dataflow.)
The Ascend components in each Dataflow are found under the 'Table' menu.
Occasionally the upgrades in Tableau, Ascend, or the connectors can cause problems with matching capital letters in the component names. If you have trouble, try to use the exact name of the component, In addition, sometimes the "Add New Table" function in Tableau can help trigger a match that is missed by the search function. We continue to monitor these issues, please alert us via our Slack community if your problems persist.
Once visible in Tableau, the Ascend components behave just like a tables.
To customize your query to focus in on the data you need from an Ascend component, use the Tableau Custom SQL function:
Tip: Use the Custom SQL function to modify an existing table and start building your query with a working SQL statement.
That's it for this introduction. Start bringing in the appropriate tables, define relationships, and get to enjoying direct access to Ascend from Tableau!
The process is similar to Desktop, except for the .taco file location.
- For Linux, please install to
/etc/tableau/tableau_connectors(creating the directory if it does not exist).
- Ensure restarting the server with
- Publish a workbook from Tableau desktop to Tableau Server to test the connection
Updated 6 months ago