Strategy ONE
Connect to Tableau Server
If you are a Tableau user and want to connect data sources from your Tableau environment to Strategy Mosaic, you can use the connectors available through your Tableau license, such as Starburst. Be aware that it is your responsibility to ensure compliance with the license terms and conditions that apply to any third-party software, services, or tools you use.
You can use Universal Semantic Layer to easily access live data across Strategy and multiple tools including Tableau. Tableau Server supports OAuth, Standard, and LDAP authentication methods.
See the following steps to install the Tableau connector and access the connector in your Tableau Server and Strategy environments.
Prerequisites
-
You must have the Use Universal Access and Use Application Tableau privileges.
-
Cognitive search index must be enabled. For more information, see Cognitive Search.
Install the Tableau Connector
-
Download the Trino JDBC Driver from the following URL:
https://trino.io/docs/current/client/jdbc.html
-
Add the
.jar
file to your Tableau driver's folder:-
Mac:
/Users/yourusername/Library/Tableau/Drivers
-
Windows:
C:\ProgramFiles\Tableau\Drivers
-
-
Download the connector file.
For access to this file, contact your Strategy account team.
-
Add the
.taco
file to your Tableau connector's folder:-
Mac:
/Users/yourusername/Documents/My Tableau Repository/Connectors/
-
Windows:
C:\Users\yourusername\Documents\My Tableay Repository\Connectors
-
Access Strategy Data in Tableau Using the Strategy One by Strategy Connector
-
Open Tableau.
-
Click New and Create Workbook.
The Connect to Data dialog displays.
-
Click Connectors.
-
Find and select Strategy One by Strategy.
-
In General, type your Server path. This should be your Strategy environment URL. For example,
xxxxxx.cloud.microstrategy.com
. -
In the Authentication drop-down list, choose OAuth Authentication, Standard, or LDAP.
If you choose OAuth Authentication and need to create an OAuth client, see Configure an OAuth Client for Strategy One Authentication.
-
Click Sign In.
-
Enter your Strategy user credentials.
-
Choose a Project from the drop-down list.
-
Double-click a table and click Sheet 1 at the bottom of the window.
-
Double click your data to add it to your sheet and view your Strategy data.
Configure an OAuth Client for Strategy One Authentication
-
In Tableau, click Settings.
-
In OAuth Clients Registry, click Add OAuth Client.
-
Expand the Connect Type drop-down list and choose Strategy One by Strategy.
-
Expand the OAuth Provider drop-down list and choose Strategy One Authentication.
-
Optionally enter a value in OAuth Instance URL.
-
Enter values in Client ID, Client Secret, and Redirect URL.
-
Click Add OAuth Client.
-
Click Save.
-
Proceed to connect to your Strategy environment.
Access Strategy Data in Tableau Using Strategy Library
-
In Strategy Library, click Data in the Navigation pane.
-
Find your dataset.
-
Right-click your dataset and choose View in Tableau.
A
.tds
file downloads. -
Open the
.tds
file and your Strategy data displays in Tableau.