Manually install Studio Database Gateway

You can manually install Studio Database Gateway on a Windows computer or Windows Embedded device in order to have it relay connections between a project runtime and an external database.

Before you begin this task, you must have already installed the full Studio software on your computer, because doing so unpacks the standalone Studio Database Gateway software installer.

Also, you must have Administrator privileges on a computer or device in order to install any software.

Studio Database Gateway requires both .NET Framework 3.5 and .NET Framework 4.8 (or later), which are supported by but not necessarily included in all of the versions of Windows that also support this software. Before you try to install the Studio Database Gateway software on a computer or device, make sure both versions of .NET Framework are installed and turned on. For more information, see Install the full software.

In most cases, the project runtime and the database gateway run on the same computer or device: the database gateway software is installed as part of the project runtime software, and the database gateway runs automatically when the project itself is run. If this is the case for your project, and if you are satisfied with the runtime performance of your project, you do not need to do anything more and you may skip this task.

In some cases, however, it is advantageous or even necessary to manually install and run Studio Database Gateway:

• When the target platform does not support Studio Database Gateway at all, as is the case for IoT View on Linux-based computers and devices.

• When you want to optimize network traffic between the project runtime and the database server. For example, by running the database gateway on the same computer that hosts the database server itself and then taking advantage of the Decimation feature of the Trend Control object. The database gateway implements the decimation before it relays the data to the project runtime.

• When you want to limit the number of concurrent connections to the database server. You can have several projects access the same database server through a single database gateway. As far as the database server is concerned, the only connection is the database gateway.

• When you have configured your project to save historical data to a Historian database, but the project is running on Windows Embedded:

  • For projects running in Embedded HMI on Windows Embedded, the version of the database gateway that is installed as part of Embedded HMI does not include additional files required by Historian. You can run the standalone Studio Database Gateway software installer in order to replace the previously installed version, or you can install the database gateway on another Windows computer and then reconfigure your project to use it instead.

    Embedded HMI can use AVEVA Historian only through a remote Windows gateway.

    When the gateway runs on a computer other than the project runtime, and the project saves Trend history to AVEVA Historian, make sure that:

    The Historian server certificate is trusted on the gateway computer. See Trust the AVEVA Historian server certificate.

    The gateway computer can ping the Historian server, and TCP port 32565 is allowed from the gateway computer to the Historian server. See Historian ports and network prerequisites.

For more information, see Support for AVEVA Historian.

You can install Studio Database Gateway on any Windows computer or Windows Embedded device on your network, as long as that computer or device can communicate with both the project runtime and the database server.

To manually install Studio Database Gateway:

1. Locate the standalone Studio Database Gateway software installer (GatewaySetup.exe) in your Studio program folder.

   If the full Studio software was installed at its default location, the standalone Studio Database Gateway software installer should be located at:

   C:\Program Files (x86)\AVEVA\AVEVA Edge 2026\ Redist\DatabaseGateway\GatewaySetup.exe

2. Copy the installer to the Windows computer or Windows Embedded device on which you want to install the database gateway.

   You can either copy the installer across the network or move it on a portable hard drive.

3. Run the installer, and then follow the installation instructions.

   There are no installation options for you to select.

   Note: The installer will try to confirm that .NET Framework 4.8 is installed on the computer or device. If it cannot, it will cancel the installation.

When the installation is finished, if the software was installed at its default location, it should be located at:

C:\Program Files\Studio Database Gateway 2026\

Remember, the database gateway runs automatically (that is, when the project itself is run) only if it is installed on the same computer or device as the project runtime. If the database gateway is installed on another computer or device, you must manually run it before you run your project, so that your project can find it and connect to it. For more information, see Manually running Studio Database Gateway.