Creating Kyvos connection for Excelerate

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

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

Creating Kyvos connection for FluenceXL Desktop

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

   Open

   

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

   Open

   

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 Login checkbox and click Connect.

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.
    

Connecting to FluenceXL Desktop with Kyvos via SSO connection

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

1. On FluenceXL 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.
   

Publishing a connection to FluenceXLweb

1. Navigate to the Kyvos tab on FluenceXL 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 FluenceXL web 

1. Go to FluenceXL Web.

2. Select Adhoc Grid and go to the New Connection area.

3. From the Connect to list, select the Published Connection option.

4. Choose the connection on which the grid is to be designed and click Select.

5. The Grid designer is displayed on the chosen connection. Here you can design the grid as you like and then click OK to load the grid.

Publishing a workbook to FluenceXL web

1. Navigate to the Kyvos tab on FluenceXL Web and click Publish to Web > Publish Workbook to web.

2. On the publisher dialog box, select the Web site name from the drop-down and provide the Workbook Name.

3. From the Folder to Publish to list, select the folder where the workbook needs to be published and click Publish.

4. To see the published workbook, go to FluenceXL Web and navigate to the folder specified earlier in the Publisher window.

5. Select the workbook name. The grid loads on the UI as shown below.