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 NLB DNS in the Excel Add-in for Historian. You can add multiple NLBs; however, you can connect with a single NLB 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 Amazon Network Load Balancer (NLB) DNS.

    Tip: To find the NLB DNS:
    1. Access the EKS cluster on which you have deployed Proficy Historian for AWS.
    2. Access the EC2 instance.
    3. In the navigation pane, under Load Balancing, select Load Balancers.
    4. Select the load balancer for which you want to find the DNS.
    5. In the Description section, copy the DNS name.
    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 AWS.
    Password Enter the password to connect to Proficy Historian for AWS.
    Tip: This is the value you entered in the Password field under Proficy Authentication Configuration when you created the stack.
  5. Select OK.
    The Excel Addin is connected to the Historian server. You can now query data or manage tags.