Applies to:
Kyvos Enterprise Kyvos Azure Marketplace
Kyvos AWS Marketplace Kyvos Applies to: 
Kyvos Enterprise Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace
Kyvos Azure Marketplace Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI) Kyvos Free (
...
Tableau Online is a hosted version of the Tableau server that helps to make business intelligence decisions faster and easier. Tableau Online is hosted in the cloud for user availability. It allows you to Distributes Dashboards and share your discoveries with everyone. Users can easily utilize features of Tableau Online access through Tableau mobile apps.
...
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 Online. 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 Online. Correspondence is done through an outbound encrypted connection between your data and your Tableau Online site.
Prerequisites
Kyvos ODBC driver must be installed on that machine.
Tableau Bridge
...
...
must be installed on any user's machine that has Admin Rights, and the machine must be able to connect/ping to both Tableau Online and Kyvos.
Tableau User Role must have Site Administrator Creator permission.
...
Configuring Tableau Bridge
Login to Tableau Bridge with Tableau Online Credentials.
Login to Tableau Online 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 Online and create visualizations on workbooks using that data source.
| Panel | ||||||
|---|---|---|---|---|---|---|
| ||||||
Important It is not possible to connect private network data through the Tableau Online interface. You must first publish the data through Tableau Desktop using Tableau Data Source file |
...
Accessing data available in open network
Kyvos supports Tableau Online 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 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 Online 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:
Parameter Description Server
IP address or hostname of your Kyvos Web App Server
HTTP Path
Client path for Kyvos Web portal.
Port
TCP port that the Kyvos Web App server uses to listen to client requests.
Username
Kyvos Web App Server Username.
Password
Kyvos Web App Server Password.
Require SSL
Select the checkbox if connecting to an SSL Server.
Initial SQL
Optionally, select to specify a SQL command to run at the beginning of every connection, such as when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. For more information, see Run Initial SQL.
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:
Parameter Description Server IP address or hostname of your Kyvos Web App Server without HTTP. For example, use kyvos_install NOT http://kyvos_install .
Port the number of the TCP port that the Kyvos Web App Server uses to listen for client requests. If using SSL, then use port 443, else use port 8081.
Spark Server Type
Select the SparkThriftServer (1.1 and later) option Authentication Mechanism Select the Username and Password option.
Thrift Transport Select the HTTP option. User Name Enter your Kyvos BI Server username. Password Enter your Kyvos BI Server password. HTTP Path Client path for Kyvos Web portal. Require SSL Select the checkbox if connecting to an SSL Server.
Initial SQL Optionally, select to specify a SQL command to run at the beginning of every connection, such as when you open the workbook, refresh an extract, sign in to Tableau Server, or publish to Tableau Server. For more information, see Run Initial SQL.
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 Online 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.
| Anchor | ||||
|---|---|---|---|---|
|
...
Download and install Tableau drivers for Spark Simba connectivity from the Tableau website according 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 Online. 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 Online as a server and click Connect. You will not get this dialog box if you are already signed in.
...
On the Tableau Online sign-in screen, use Tableau Online 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.
Info Indexing will not work in Ask Data if you select the Prompt User Authenticaltion mode.
Select the Maintain connection to a live data source option (Kyvos does not support extract).
...
Your data source is published on Tableau Online under the selected Project. You can now use this data source to create workbooks.
...
User impersonation with Kyvos
To work with user impersonation through initial SQL with Tableau Online, the Username in the database (Kyvos) must be the same as the Tableau Online username, in the username@domain.com format.
Points to remember
Tableau Online 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 Online. For details, refer to Tableau Documentation.
Tableau Online does not support published connections that use Kerberos authentication. For details, refer to Tableau Documentation.