Versions Compared

Key

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

...

On the Tableau window, select the Kyvos SparkSQL 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:

    1. In the Server field, type the IP address or hostname of your Kyvos Web App Server without HTTP. For example, use kyvos_install NOT http://kyvos_install.

    2. In the Port field, type 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.

    3. In the Spark Server Type field, select the SparkThriftServer (1.1 and later) option.In the Authentication Mechanism field, select the Username and Password option.In the Transport field, select the HTTP option.

    4. Choose any one of the following Authentication type:

      • Username and Password

        • Enter your Kyvos BI Server credentials in the User Name and Password

        • In the Transport field, select the HTTP option.

        • In the HTTP Path 

      field, type your client path.
        • field, Kyvos/sql

          image-20250221-072654.pngImage Added
      • Kerberos

        • Enter Realm, Host FQDN, and Service Name

        • In the Transport field, select the HTTP option.

        • In the HTTP Path field, Enter Kyvos/sqlSSO

          image-20250221-075135.pngImage Added
    5. Select the Require SSL checkbox if connecting to an SSL server.

    6. (Optional) Select Initial SQL 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

...