Create a Historian Connection

The first time you start a ViewApp containing the HistoricalTrendApp, you must create a server connection to the Historian. To create a connection, you need your assigned Historian username and password.

To create a Historian connection

1. Start the ViewApp containing a HistoricalTrendApp.

2. Show the ViewApp pane containing a HistoricalTrendApp.

3. On the Tools menu, select Servers, or click the Configure the servers toolbar icon.

   The Server List Configuration dialog box appears, which shows a list of connected servers or servers that were configured in the past.

   

4. In the Server box, type the name of the server to which you want to connect.

   • For an On-Premises Historian, type the name of the server where it is hosted.

   • For a Managed Historian, you can use a name of your choice.

   • For a SQL Server named instance, use the format <server_name>\<instance_name>.

     Note: If the default port for the SQL Server is changed, the Historian Client server configuration should be given as <server_name>[\<instance_name>], <port_number>. For example:
     

5. In the Connection section, specify the type of connection you want to use:

   • Database (SQL Server): Choose this option to connect to the SQL Server database.

   • OData Feed: Choose this option to connect to the open data protocol feed. Then specify the URL and continue to step 7. You can connect using this option only if you are using a Managed Historian connection.

     Notes: If you select OData Feed to connect to the Historian Server, all the fields related to Login section become unavailable and the Managed Account option becomes deselected automatically.
     
     By default, the Historian's OData server supports unencrypted HTTP connections. To use an encrypted (HTTPS) OData connection, you will first need to install and configure an SSL client certificate. Contact AVEVA Technical Support for details.

6. In the Login section, do the following:

   1. To log on to the server using integrated security, click Windows Integrated and then go to the next step.

   2. To log on to the server using SQL Server credentials, click SQL Login and configure the following login details. Then, go to step 7.

      • Login ID: Type your assigned Historian username. If your system administrator has not assigned you a username and password, you may use one of the default user accounts, which are automatically configured during a typical Historian installation.

      • Password: Type the password that is associated with the username. Select the Remember password check box to specify for the system to remember your password.

7. In the Timeouts in seconds area, configure the time allocated for the database connection and the query execution.

   • Connection: The connection time-out period in seconds. Valid values are 1 to 600.

   • Query: The query time-out in seconds. Valid values are 1 to 600.

8. Select Add.

   After several seconds, the server connection should be established.

9. Click Close. An error message appears if a connection cannot be made to the Historian server.