Configure the ODBC Collector Using Historian Administrator

About this task

You can establish a connection between the ODBC collector and an ODBC server, and set the recovery time and throttle value by configuring the ODBC collector.
Note: ODBC Driver for SQL is required to install the ODBC collector and connect it with the ODBC server. If you install the ODBC collector and the ODBC server on the same machine, install the ODBC Driver for SQL on the same machine as well.

Procedure

  1. Access Historian Administrator.
  2. Select Collectors, and then select the ODBC collector instance that you want to connect to an ODBC server.
  3. Select Configuration.
    The Configuration section appears.
  4. Enter values as specified in the following table.
    Field Description
    Server Name The name of the ODBC server database.
    User Name The username of the ODBC server database.
    Password The password of the ODBC server database.
    Recovery Time (hours) The maximum time, in hours, for which the collector will attempt to recover data after the collector is started or when connection between the collector and the ODBC server is re-established. This time is calculated as the duration between the current time and the last known write time.

    Continuous data collection is resumed only after the previous data has been recovered.

    By default, this value is set to 0, which means data recovery is not attempted. The maximum value you can provide is 168 hours (that is, 7 days).
    Throttle (Milliseconds) The frequency, in milliseconds, at which you want the ODBC collector to query the ODBC server for tag data. This will minimize the load on the ODBC server. You can enter a value up to 16 hours.
    Note: If this field is blank, enter the required minimum value of 100 milliseconds.
    If you have provided incorrect ODBC server details (that is the server name, username, and password) either in Historian Administrator or in the ODBC_Mapping.xml file, the ODBC collector cannot connect with the OBDC server. To fix this issue:
    1. Delete the ODBC collector instance.
    2. Provide values for the following properties in the registry key HKLM\Softwares\GE Digital\iHistorian\Services\ODBCCollector:
      • General1: ODBC server name
      • General2: ODBC server username
      • General3: ODBC server password
    3. Ensure that the mapping file is configured correctly.
    4. Restart the collector.
    If this workaround is not successful, restart the collector instance.