Versions Compared

Key

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

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

...

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

Image ModifiedKyvos AWS Marketplace  Image ModifiedKyvos Single Node Installation (Kyvos SNI)  Image ModifiedKyvos 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.

...

  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.

    Info

    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

...

Connecting to Kyvos semantic models through Tableau interface

...

  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:

    ParameterDescription

    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.

...

Connecting to Kyvos semantic models through Tableau interface

...

  1. In the displayed Spark SQL dialog box, specify your connection information as described below:

    ParameterDescription
    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 TransportSelect the HTTP option.
    User Name Enter your Kyvos BI Server username.
    PasswordEnter your Kyvos BI Server password.
    HTTP PathClient 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

...