Create an ODBC Collector

Before you begin

  1. Deploy Proficy Historian for Azure Cloud.
  2. Install collectors. You can install them on-premises or on an Azure Virtual Machine in a VNet (which can be the same one as the Historian server or a different one).

About this task

The ODBC collector collects data from an application based on an ODBC driver and stores the data in Data Archiver. It supports collecting of all the Historian supported data types of data from the ODBC server.
Features:
  • You can browse the source for tags and their attributes on an ODBC server that supports browsing.
  • Only the unsolicited data collection is supported; when changes to the ODBC source tags are detected, they are sent to the Historian server. The minimum poll interval is 100ms. The collector duplicates raw samples from the ODBC server into the Historian data archive.
  • The supported timestamp resolution is 1ms.
  • Floating point, integer, and string data are supported.
Supported Data Attributes:
Historian Data Type ODBC Server Data Type
ihByte Byte
ihFloat SingleFloat
ihDoubleFloat DoubleFloat
ihInteger SingleInteger
ihDoubleInteger DoubleInteger
ihScaled Not applicable
ihFixedString Not applicable
ihVariableString Not applicable
ihBlob Not applicable
ihTime Not applicable
ihInt64 Not applicable
ihUInt64 Not applicable
ihUInt32 Not applicable
ihUInt16 Not applicable
ihBool Not applicable
Limitations:
  • A single collector instance can collect data from a single ODBC server. To collect data from multiple ODBC servers, you must add multiple instances.
  • Only good and bad quality types are supported. OPC Quality and OPC Subquality are not supported.

Procedure

  1. Run Command Prompt as an administrator.
  2. Run the AzureCloudHistorianConfigurationUtility.exe file. It is provided along with the collectors installer. After you install collectors, it will be available in the C:\Program Files\GE Digital\Historian Cloud Config folder by default.
  3. Enter the number corresponding to creating a collector instance.
    A list of collectors that you can create appears.
  4. Enter the number corresponding to the collector that you want to create.
  5. Enter the following details:
    Field Description
    Interface Name Enter the name that you want to provide for the collector instance.
    Azure Load Balancer IP

    Enter the Azure Load Balancer IP. A value is required.

    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.
    Username Enter the username to connect to Proficy Historian for Azure Cloud. A value is required.
    Password Enter the password to connect to Proficy Historian for Azure Cloud. A value is required.
    Tip: For the default user, ihCloudHistAdmin, this is the value you entered in the Password field at the time of deployment.
    ODBC Server Enter the host name or IP address of the ODBC server. A value is required. By default, the local host name is considered.
    ODBC Username Enter the username to connect to the ODBC server. A value is required.
    ODBC Password Enter the password to connect to the ODBC server. A value is required.
    The ODBC collector is created and started.