Tableau Cloud on Kyvos
Overview
Tableau Cloud is a fully hosted, cloud-based version of Tableau Server that enables faster and easier business intelligence. It provides on-demand access, allowing users to create, share, and distribute dashboards seamlessly, including through Tableau mobile apps for anytime access.
Kyvos supports SQL connectivity with Tableau Cloud, enabling users to analyze Kyvos data directly within Tableau Cloud environments.
Note
From the Tableau Cloud version 2025.2.0 (20252.25.0707.1658), you can view the username, password, and OAuth authentication in the Kyvos connector. However, Tableau Cloud does not support the OAuth authentication through Tableau cloud interface.
Accessing data from Tableau Cloud
You can access both open network data and data stored in a private network from Tableau Cloud. To access the data stored in a private network within a secured firewall, you need to create a Tableau Bridge to access it, as Tableau Cloud cannot directly connect to such data.
The following sections explain the steps and procedures for both.
Accessing data stored in private network using Tableau Bridge
Accessing data available in open network
Accessing data stored in private network using Tableau Bridge
Tableau Bridge is a program through which you can connect to your published data sources by querying the local data and securely sending them across to Tableau Cloud. This keeps your data updated and refreshed. Tableau Bridge functions as the channel through which access is gained to the private network data such as Excel files and SQL Server data from Tableau Cloud. Correspondence is done through an outbound encrypted connection between your data and your Tableau Cloud site.
Prerequisites
Kyvos ODBC driver must be installed on that machine.
Tableau Bridge and Kyvos ODBC Driver must be installed on any user's machine that has Admin Rights, and the machine must be able to connect/ping to both Tableau Cloud and Kyvos.
Tableau User Role must have Site Administrator Creator permission.
Configuring Tableau Bridge
Login to Tableau Bridge with Tableau Cloud Credentials.
Login to Tableau Cloud in a Web browser.
Click Settings (icon at bottom-left) and then click the Bridge option.
The Default Pool shows details of the machine where the Bridge is installed and configured.
In the Pooling area, click the Add New Pool. Move your machine, which is available inside the default pool, to the newly added pool.
In the Private Network Allowlist, click Add New Domain and add the required domain, select the pool that you created, and then click Save.
The bridge is now configured, and you can publish the data source to Tableau Cloud and create visualizations on workbooks using that data source.
Important
It is not possible to connect private network data through the Tableau Cloud interface. You must first publish the data through Tableau Desktop using Tableau Data Source file
Accessing data available in open network
Kyvos supports Tableau Cloud connection in open networks through:
Kyvos Connector
Spark SQL Connector
Kyvos Connector
You can connect Tableau to the Kyvos semantic models using any of the following two methods:
Through Tableau interface
Connecting to Kyvos semantic models through Tableau interface
To connect Tableau to a Kyvos semantic model and set up the data source, using the Kyvos connector, perform the following steps.
Log into Tableau Cloud using your credentials.
Click Explore from the navigation pane and then select or search for the Project on which you are working.
Click the New > Workbook option.
On the New Workbook screen, click the Data > Connect to Data option.
From the Connect to Data screen, select the Kyvos option from the Connectors list.
On the displayed Kyvos dialog box, enter your connection information as:
Click Sign In. On the Data Source page, select your Schema, then select the Table that you want to browse in Tableau. The Kyvos data store is loaded in Tableau. You can now use your data to create reports.
Spark SQL connector
You can connect Tableau to the Kyvos semantic models using any of the following methods:
Through Tableau interface
Connecting to Kyvos semantic models through Tableau interface
On the Tableau window, select the Spark SQL option from the To a Server list on the navigation pane.
In the displayed Spark SQL dialog box, specify your connection information as described below:
Click Sign In. On the Data Source page, navigate to the Schema of the semantic model you want to connect to and select the semantic model. You can search for the Schema and then for the name of the semantic model/table.
Drag the selected table to the right pane. Next, go to Sheet1 to start browsing the semantic model.
Optionally, you can preview the data by using the Update Now
The levels, attributes, and measures in the semantic model are listed under the Dimensions and Measure sections based on data types or Tableau’s recommendations based on field names. You can start querying and analyzing your data.
Connecting Tableau Cloud to Kyvos through semantic model metadata TDS file
When you use a TDS file, you will see the dimensions, hierarchies, measures, levels, and attributes as they are configured in the Kyvos semantic model. If you generate a TDS file from the Kyvos web portal and publish it to the Tableau Server, you don’t need to provide the connection details to your users. A TDS file contains the metadata of the semantic model and connection information.
Creating TDS File in Kyvos
To create a TDS file in Kyvos, perform the following steps.
From the Kyvos Web portal, click Toolbox > Utilities.
Select the Export Semantic Model Metadata option from the list.
Select the semantic models you want to browse and click Download Selected. The Download Selected Semantic Model Metadata dialog box is displayed.
Here, select any of the following options from the Format drop-down.
Tableau data source (Kyvos ODBC)
Tableau data source (Spark SQL)
Provide the Tableau Version on which you will be using the TDS file.
Provide the Server IP/Hostname, Server Port, and Username (optional) used to connect to the Kyvos web portal.
Click Download. Save the Tableau TDS file on your computer network.
After the creation of the TDS file, you need to edit the connection for Kerberos. Refer existing documented Kerberos connection guide.
Publishing Data source to Tableau Cloud
Download and install Tableau drivers for Spark Simba connectivity from the Tableau website according to your requirements. See the Tableau Desktop on Kyvos section to know more about how to connect Tableau Desktop to Kyvos.
Open Tableau Desktop and click the File > Open option.
On the Open dialog box, select the .tds file you have downloaded from the Kyvos portal and click Open. Kyvos semantic model data loads and is displayed in the left pane.
Now you can create worksheets/dashboards or directly publish data sources/workbooks on Tableau Cloud. For this, click any sheet and go to the Server menu. Select the Publish data source option.
On the Tableau server sign-in dialog box, select Tableau Cloud as a server and click Connect. You will not get this dialog box if you are already signed in.
On the Tableau Cloud sign-in screen, use Tableau Cloud credentials to log in.
On the Kyvos sign-in screen, enter the Kyvos credentials to access the dataset.
Once logged in, you will be prompted to select Project folder, Data Source Name, Description (optional), Tags, Permission, and Authentication as Server Run AS Account.
Select the Maintain connection to a live data source option (Kyvos does not support extract).
Your data source is published on Tableau Cloud under the selected Project. You can now use this data source to create workbooks.
OAuth2.0 Connectivity on Tableau Cloud using Kyvos Connector
You can use OAuth on Tableau Cloud using Kyvos connector via Tableau bridge configured on Windows. For further details, click here.
User impersonation with Kyvos
To work with user impersonation through initial SQL with Tableau Cloud, the Username in the database (Kyvos) must be the same as the Tableau Cloud username, in the username@domain.com format.
Points to remember
Tableau Cloud does not support connections to any semantic model-based data source or multidimensional database. Hence, you cannot publish workbooks made through MDX connection on Tableau Cloud. For details, refer to Tableau Documentation.
Tableau Cloud does not support published connections that use Kerberos authentication. For details, refer to Tableau Documentation.