Litmus Excel AddIns
Litmus DataHub AddIns

Manage DataHub Connections

5min

You can manage your datahub connections by viewing connection details in a paginated table. It supports a fixed layout of five rows per page, enabling easy navigation through multiple connections. Additionally, you can edit connection parameters and delete connections when necessary.

Before You Begin

  • Ensure that connections have been previously created and are visible in the connection table. See Define DataHub Connections for details.

Step 1: Access the Manage DataHub Connections Form

  1. Navigate to the Manage DataHub Connections section. The Litmus DataHub Connections window pop-up appears.

    Document image
    

Step 2: View Connection Details

You will see a table or list displaying your available connections. Refer to the following actions you can take from this page:

Document image


Action

Details

[1] Connections

Shows the total number of defined connections.

[2] Connection Name

Displays the defined connection name. Click on the connection name to open the connection edit dialog box.

[3] Server IPv4

Helps identify the specific Litmus Edge device or external database connection.

[4] Database

Displays the name of your database.

[5] User

Indicates which database user user is associated with the connection.

[6]Created By

Shows the creator of the connection, which is useful in multi-user scenarios.

[7] Actions

  • View: Select the information (eye) icon to open the connection edit dialog box.
  • Delete: This option (bucket icon) is only visible for connections that are not currently associated with a query. If a connection is linked to an existing query, it cannot be deleted to prevent potential issues with query management.

Step 3: Edit a Connection

To enter the edit mode, you have two options: click on the [2] Connection Name or select the [7] Actions: View to open the connection details.

  • In edit mode, modify necessary fields such as the IP address, port, user credentials, password, or timeout settings.
  • Confirm the updates to complete the editing process.
Document image


Notes:

  • The datahub connections are managed in an independent workbook created outside of the add-in. This design enables multiple users to work on the same file concurrently.
  • The interface supports tracking of connections created by various users, ensuring transparency and accountability in collaborative environments.