Connect to a Server

About this task

The Historian Interactive SQL application allows you to make multiple connections to the same server or different servers. This allows you to look at data from different servers.

Procedure

  1. Access the Historian Interactive SQL application.
  2. Select File > New.
    The Historian Interactive SQL Login window appears.
  3. In the Server field, 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.
  4. Enter the username and password to connect to the server. If you do not enter user credentials, the currently logged-in user is considered. Leave the Domain field blank.
  5. Select OK.
    A new session of the Historian Interactive SQL application appears, and it is connected to the server that you have specified. The session begins with the default values for SET variables.
    Note: If modifications or additions are made to the list of available Historian servers using any of the Historian clients (Excel, non-web Administrator, or iFIX WorkSpace: Expression Builder and iFIX Migration Tools), those settings are global for any Historian clients running on that computer.