Versions Compared

Key

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

...

  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.

    4. In the Authentication Mechanism field, select the Username and Password option.do the following:

      1. Username and Password: Provide your Kyvos username and password.

      2. Kerberos: Provide the following that you mentioned when configuring Kerberos SSO:

        1. Realm

        2. Host FQDN

        3. Service Name

    5. In the Transport field, select the HTTP option.Enter your Kyvos BI Server credentials in the User Name and Password

    6. In the HTTP Path field, type your client path.

      • If authenticating through Username and Password, you must provide HTTP path as kyvos/sql

      • If authenticating Kerberos, you must provide HTTP path as kyvos/sqlSSO

    7. Select the Require SSL checkbox if connecting to an SSL server.

    8. (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

...