Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

PI Interface for Relational Database RDBMS via ODBC

Learn about how to install interface service manually

Learn about how to install interface service manually

  • Last UpdatedAug 19, 2025
  • 2 minute read

Help for installing the interface as a service is available at any time with the command:

RDBMSPI.exe /help

  1. Open a Windows command prompt window and change to the directory where the RDBMSPI.exe executable is located. Then, consult the following table to determine the appropriate service installation command.

    In the following Windows service installation commands you may use either a slash (/) or dash (-) as the delimiter.

    Windows Service Installation Commands on an Interface Node or a PI Data Archive Node with Bufserv implemented

    Manual service

    RDBMSPI.exe /install /depend "tcpip bufserv"

    Automatic service

    RDBMSPI.exe /install /auto /depend "tcpip bufserv"

    *Automatic service with service ID

    RDBMSPI.exe /serviceid x /install /auto /depend "tcpip bufserv"

    Windows Service Installation Commands on an Interface Node or a PI Data Archive Node without Bufserv implemented

    Manual service

    RDBMSPI.exe /install /depend tcpip

    Automatic service

    RDBMSPI.exe /install /auto /depend tcpip

    *Automatic service with service ID

    RDBMSPI.exe /serviceid X /install /auto /depend tcpip

    * When specifying service ID, the user must include an ID number. It is suggested that this number correspond to the interface ID (/id) parameter found in the interface .bat file.

  2. Check the Microsoft Windows Services control panel to verify that the service was added successfully. The services control panel can be used at any time to change the interface from an automatic service to a manual service or vice versa.

    The service installation commands in this section create an interface service that runs under a low-privilege built-in account. On Windows 7 and Server 2012 and later, the service logs on as the service virtual account. For earlier versions of Windows, the service logs on as Network Service.

    Note: As a security best practice, AVEVA recommends running this interface service under a lest privileged account, such as a Windows service virtual account, the build-in Network Service account, or a non-administrative account that you create.

    The services control panel can change the account that the interface service runs under. Changing the account while the interface service is running does not take effect until the interface service is restarted.

TitleResults for “How to create a CRG?”Also Available in