Versions Compared

Version Old Version 1 New Version Current
Changes made by

Sarabjeet Kaur

Sarabjeet Kaur

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  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. The Download Selected Semantic Model Metadata dialog box is displayed.

  4. Here, 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.

After the creation of the TDS file, you need to edit the connection for Kerberos. Refer existing documented Kerberos connection guide

Anchor
PublishingDS
PublishingDS

...

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.

  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 as Server Run AS Account.

    Info

    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.

...