Connect the Excel Add-in with the Historian Server

Before you begin

Activate the Excel Add-in for Historian.

About this task

This topic describes how to add an Azure Load Balancer IP in the Excel Add-in for Historian. You can add multiple Azure Load Balancers; however, you can connect with a single Azure Load Balancer at a time.

Procedure

  1. Open an Excel worksheet.
  2. Select Proficy Historian > Options.
    The Proficy Historian Excel Add-in Options window appears.
  3. In the Default Server section, select Edit.
    The Historian Servers window appears.
  4. Enter values as described in the following table.
    Field Description
    Server Name

    Enter the Azure Load Balancer IP.

    Tip: To find the Azure Load Balancer IP:
    1. Go to the Azure portal.
    2. Go to the Resource Group that was specified during deployment.
    3. Select the cluster_name-IP to access the resource of type Public IP Address.
    4. Select or copy the IP Address.
    Is Default Server Select this check box if you want to set this Historian server as the default one.
    Connection Timeout Specify the time after which the connection will time out.
    User Name Enter the username to connect to Proficy Historian for Azure Cloud.
    Password Enter the password to connect to Proficy Historian for Azure Cloud.
    Tip: This is the value you entered in the Password field at the time of deployment.
  5. Select OK.
    The Excel Addin is connected to the Historian server. You can now query data or manage tags.