Applies to:Kyvos Enterprise  Kyvos Cloud (Managed Services on AWS)  Kyvos Azure Marketplace

Kyvos AWS Marketplace  Kyvos Single Node Installation (Kyvos SNI)  Kyvos Free (Limited offering for AWS)

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.

Kyvos supports SQL connectivity with Tableau Online.

Accessing data from Tableau Online

You can access both open network data and data stored in a private network from Tableau Online. 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 Online 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

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

1. Kyvos ODBC driver must be installed on that machine. 
2. 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 Online and Kyvos.
3. Tableau User Role must have Site Administrator Creator permission.
   

Configuring Tableau Bridge

1. Login to Tableau Bridge with Tableau Online Credentials.
2. Login to Tableau Online in a Web browser.
3. Click Settings (icon at bottom-left) and then click the Bridge option.
   
4. The Default Pool shows details of the machine where the Bridge is installed and configured.
5. In the Pooling area, click the Add New Pool. Move your machine, which is available inside the default pool, to the newly added pool.
   
6. In the Private Network Allowlist, click Add New Domain and add the required domain, select the pool that you created, and then click Save.
   

7. The bridge is now configured, and you can publish the data source to Tableau Online and create visualizations on workbooks using that data source.

   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
• Using Tableau Data Source File

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.

1. Log into Tableau Online using your credentials.
2. Click Explore from the navigation pane and then select or search for the Project on which you are working.
3. Click the New > Workbook option.
4. On the New Workbook screen, click the Data > Connect to Data option.
5. From the Connect to Data screen, select the Kyvos option from the Connectors list.
   

6. 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.

7. 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
• Using Tableau Data Source File

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.

1. 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.

2. 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.
3. Drag the selected table to the right pane. Next, go to Sheet1 to start browsing the semantic model.
4. 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.

1. From the Kyvos Web portal, click Toolbox > Utilities.
2. Select the Export Semantic Model Metadata option from the list.
   
3. Select the semantic models you want to browse and click Download Selected.
   
   
   
4. In the Download Selected Semantis Model Metadata dialog box, select any of the following options from the Format drop-down.
   1. Tableau data source (Kyvos ODBC)
   2. Tableau data source (Spark SQL)
5. Provide the Tableau Version on which you will be using the TDS file.
6. Provide the Server IP/Hostname, Server Port, and Username (optional) used to connect to the Kyvos web portal.
7. Click Download. Save the Tableau TDS file on your computer network.

Publishing Data source to Tableau Online

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.

1. Open Tableau Desktop and click the File > Open option.
2. 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.
3. 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.
   
4. 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.
   
5. On the Tableau Online sign-in screen, use Tableau Online credentials to log in.
6. On the Kyvos sign-in screen, enter the Kyvos credentials to access the dataset.

7. Once logged in, you will be prompted to select Project folder, Data Source Name, Description (optional), Tags, Permission, and Authentication.
   

   Indexing will not work in Ask Data if you select the Prompt User Authenticaltion mode.

8. Select the Maintain connection to a live data source option (Kyvos does not support extract).

   
9. 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

1. 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. 
2. Tableau Online does not support published connections that use Kerberos authentication. For details, refer to Tableau Documentation.