Connection Using Kyvos Tableau connector
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 offers seamless, single sign-on integration with Tableau, making data instantly accessible to decision-makers. With the newly launched Kyvos Connector for Tableau, users can connect to their data in just a few clicks.Â
You can use the Tableau Kyvos Connector ONLY for Tableau version 2019.4 and above.
To connect to Kyvos using the Kyvos Tableau connector, you must first download the Kyvos ODBC Driver and install it. You can download the driver from the Kyvos website. The driver is also available at the Tableau website.
Install the Kyvos ODBC driver.
Once the Kyvos ODBC driver is installed, 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
Tableau Software released a new custom Kyvos connector with its latest version, Tableau 2019.4. Â Here are the steps that can help you get productive right away using the Kyvos Tableau Connector.
To connect Tableau to a Kyvos semantic model and set up the data source, you must first have this connection information:
Name of the server that hosts the database you want to connect
Port number for client requests
HTTPÂ path to the server
User name and password
Are you connecting to an SSLÂ server?
(Optional) Initial SQLÂ statement to run every time Tableau connects
Here’s a sample Tableau worksheet with the Kyvos connection.
Connecting Kyvos semantic models using Tableau Data Source connection
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.
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.
In the Download Selected semantic model Metadata dialog box, select the  Tableau Data Source (Spark SQL)  option from the Format  drop-down.
Enter the details in Tableau Version, Server IP/Hostname, Server Port, and optionally the username used to connect.Click Download.
Connecting to Kyvos semantic models using TDS File on Tableau Server or Tableau Desktop
Once you have downloaded the TDS file, you can connect Kyvos semantic models using this TDS file on Tableau Server and Tableau Desktop. For this, open the TDS file in Tableau, and enter your credentials and click Sign In.
Optionally, edit the connection details by using the Edit Connection option.
Publish the TDS file and allow Tableau to pre-load the semantic model metadata. Your semantic model is now ready for your users.
Copyright Kyvos, Inc. All rights reserved.