/
Kyvos connection for Excelerate Kyvos (Excel add-in)

Kyvos connection for Excelerate Kyvos (Excel add-in)

Applies to: Kyvos Enterprise  Kyvos Cloud (SaaS on AWS) Kyvos AWS Marketplace

Kyvos Azure Marketplace   Kyvos GCP Marketplace Kyvos Single Node Installation (Kyvos SNI)

This section provides information about how to create Kyvos connected for Excelerate Kyvos (Excel add-in) Desktop and Web.

Creating Kyvos connection for Excelerate Kyvos (Excel add-in) Desktop

User name/password Authentication type

  1. On the Excelerate ribbon, click the Kyvos option and then choose Connections. The Manage Connections dialog box is displayed.

  2. Click Add. The Connections dialog box is displayed showing a list of all the recent connections.

  3. To establish a new connection, click the New Connection tab.

  4. In the Server field, provide the server URL in http://<ServerName>:<port>/<kyvos>/xmlaKyvos format.
    Here,
    <ServerName> is the IP address or DSN name of your Kyvos Server.
    <Port> is the port number on which Kyvos listens.
    <kyvos> is the web app name.

  5. Select the Requires Logon checkbox and choose authentication type as Username/Password.

  6. Provide the User credentials and click OK.

  7. Choose the required Database and Semantic Models and click OK.

  8. The connection established above is listed in the Recent Connections tab.

  9. Now you can browse the semantic model. For example, to view a grid, click Grid and Tables > Grid. The Manage Connections dialog is displayed. 

  10. Select the connection that you created, and click OK. 


    You will see the Kyvos semantic model dimensions and measures in the Design Grid.

Browser-based login/SSO

Note

The public OIDC configuration is required to use this authentication type. See the section OIDC Settings for Public Client at the OIDC based external authentication for Kyvos Web Portal page.

Before performing the following steps, you need to add the https://localhost/SSOToken.html URL in the Sign-in redirect URIs of IDP such as Okta and Azure

  1. On the Excelerate ribbon, click the Kyvos option and then choose Connections. The Manage Connections dialog box is displayed.

  2. Click Add. The Connections dialog box is displayed showing a list of all the recent connections.

  3. To establish a new connection, click the New Connection tab.

  4. In the Server field, provide the server URL in http://<ServerName>:<port>/<kyvos>/xmlaKyvos format.
    Here,
    <ServerName> is the IP address or DSN name of your Kyvos Server.
    <Port> is the port number on which Kyvos listens.
    <kyvos> is the web app name.
    Select the Requires Logon checkbox and choose authentication type as Browser-based login.

  5. Click Connect, and you will redirect to OIDC provider login page (Okta in this case). You must provide credentials and click Sign in.

  6. Now, you will connect to Kyvos if authenticate successfully through OIDC. Now, Select database and semantic models.

    You will see the Kyvos semantic model dimensions and measures in the Design Grid.

Windows SSO connection

To connect Excelerate Desktop with Kyvos via SSO connection, perform the following steps.

  1. On Excelerate Desktop, click Connections > Add.

  2. In the Server field, provide the server URL in http://<ServerName>:<port>/<kyvos>/xmlaKyvosSSO format.
    Here,
    <ServerName> is the IP address or DSN name of your Kyvos Server.
    <Port> is the port number on which Kyvos listens.
    <kyvos> is the web app name.

  3. Ensure that the Requires Login checkbox is NOT selected, and click Connect.

Working with Kyvos connection for Excelerate Kyvos (Excel add-in) Web

Publishing a connection to Excelerate Kyvos (Excel add-in) Web

  1. Navigate to the Kyvos tab on Excelerate Kyvos (Excel add-in) Web and click Publish to Web > Publish connection.

  2. Provide the Web site where the connection needs to be published.

  3. Provide a connection Name and select the folder where the connection needs to be published.

  4. Click OK.

Using Published connection from Excelerate Web 

Copyright Kyvos, Inc. 2025. All rights reserved.