Installing Local Processing Hub on Windows using Zip File

This section describes the requirements and step-by-step instruction on how to install the on Windows using Zip file.

For installing the Local Processing Hub on Windows using installer, see .

For installing High-Volume Agent (HVA) on Windows using installer or zip file, see or respectively.

The installation file for Windows is available for download in .exe and .zip format. The compressed file (.zip) distribution is normally used as an alternative for the Windows executable based (.exe) distribution. Also, the installation steps are different on both formats.

Requirements

Following are the prerequisites for installing the Local Processing Hub on Windows:

Sufficient disk space
Ensure sufficient disk space is available on the machine where this installation will be performed. For more information, see .
Compatibility
Check whether the Fivetran Local Data Processing version is compatible with the operating system and DBMS. Refer to the relevant section or read the COMPATIBILITY section in the release notes (available under the tab in the Fivetran ).
Installation file
Local Processing Hub System installation file for Windows (e.g. fivetran-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip). This file can be downloaded from the tab in the Fivetran . For more information, see .
Database for Local Data Processing repository
Local Data Processing uses its repository database to store the replication definitions (which tables must be replicated between which 'locations') as well as run-time status (which jobs are currently running). For databases supported as a repository, see section .
Access to source and target locations
For the Local Processing Hub System to access a source or target database directly, the database connectivity (e.g. ODBC drivers) must be installed on the hub machine. For more information, see .
version 5.6 or higher must be installed. If Perl is installed after the installation of Local Processing Hub System, then the must be destroyed and recreated.
Windows user account privileges.
- Elevated user account privilege is required for running the Local Processing Hub System executable/installer. Normally this means the user must supply an administrator password interactively.
- The user account (e.g. fivetran) which will operate the Local Processing Hub System must have Log on as a service policy enabled.
  User account policies can be managed using the Windows Local Security Policy console (accessible from Control Panel ▶ Administrative Tools). The shortcut command to access this console is secpol.msc. For more information about enabling this policy, refer to the .

Install Steps

Perform the following steps in the user account that will be used for operating the Local Processing Hub System:

Configure the environment variables HVR_HOME, HVR_CONFIG, and HVR_TMP for your operating system. Each of these environment variables should be pointed to the installation directories - hvr_home, hvr_config, and hvr_tmp.
Environment variables set using setx command are available in the future command windows only and the environment variables set using set command are available in the current command window only.
```
setx HVR_HOME C:\fivetran\hvr_home
content_copy
```
```
setx HVR_CONFIG C:\fivetran\hvr_config
content_copy
```
```
setx HVR_TMP C:\fivetran\hvr_tmp
content_copy
```
```
set HVR_HOME=C:\fivetran\hvr_home
content_copy
```
```
set HVR_CONFIG=C:\fivetran\hvr_config
content_copy
```
```
set HVR_TMP=C:\fivetran\hvr_tmp
content_copy
```
Also, add the executable directory path (e.g C:\fivetran\hvr_home\bin) to the environment variable PATH.
```
setx PATH "%PATH%C:\fivetran\hvr_home\bin"
content_copy
```
```
set PATH=%PATH%;C:\fivetran\hvr_home\bin
content_copy
```
Alternatively, environment variables can be configured using Windows GUI.
1. Navigate to Control Panel ▶ System and Security ▶ System ▶ Advanced system settings
  Alternatively, use the command sysdm.cpl to open System Properties.
2. In Advanced tab, click Environment Variables...
3. In the section System variables or User Variables for user_name, click New.
  1. Enter Variable name (e.g, HVR_HOME) and Variable value (e.g, C:\fivetran\hvr_home).
  2. Click OK.
  3. Repeated the above steps for each environment variable.
4. Add the executable directory path (e.g C:\fivetran\hvr_home\bin) to the environment variable PATH.
  1. In the section System variables or User Variables for user_name, from the list of variables, select Path and click Edit....
  2. Click New and enter the path for the executable.
  3. Click OK.
Create the installation directory - hvr_home (e.g. C:\fivetran\hvr_home).
```
md %HVR_HOME%
content_copy
```
- other directories (hvr_config and hvr_tmp) will be automatically created as needed.
- hvr_home is regarded a read-only directory. The user files saved in this directory will be moved to a backup directory when starting the Local Processing Hub System for the first time or after an upgrade.
Uncompress (unzip) the installation file (e.g. fivetran-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip) into the hvr_home directory.
```
cd %HVR_HOME%
content_copy
```
```
tar -xf C:\Users\Admin\Downloads\fivetran-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip
content_copy
```
Alternatively, files can be uncompressed using the 'Extract All' option in Windows GUI.
Configure the TCP listening port on which the Local Processing Hub Server will listen for connection request.
The secure HTTP protocol (HTTPS) is preferred, but this requires a private-key and public-certificate. This pair of files must have been generated for the hub machine's DNS host name, and signed by a certificate trusted by web browsers.
- If private-key and public-certificate files are available (e.g. mycert.priv_key and mycert.pub_cert), use them to configure HTTPS:
  1. Create the following directories - hvr_config, etc, cert.
```
md %HVR_CONFIG%
content_copy
```
```
md %HVR_CONFIG%\etc
content_copy
```
```
md %HVR_CONFIG%\etc\cert
content_copy
```
  2. Copy the private-key and public-certificate files into the cert directory, and rename them as hvrhubserver.priv_key, hvrhubserver.pub_cert respectively.
```
copy mycert.priv_key %HVR_CONFIG%\etc\cert\hvrhubserver.priv_key
content_copy
```
```
copy mycert.pub_cert %HVR_CONFIG%\etc\cert\hvrhubserver.pub_cert
content_copy
```
  3. Set the HTTPS and HTTP ports by using the command .
```
hvrhubserverconfig HTTPS_Port=4341 HTTP_Port=4340
content_copy
```
    Port 4341 and 4340 is recommended for Local Data Processing's use of HTTPS and HTTP protocol respectively.
    If HTTPS is configured, then connections to the (unencrypted) HTTP port are simply redirected to the HTTPS port
  4. If the private-key is encrypted, optionally, you can set password for the private-key.
```
hvrhubserverconfig HTTPS_Private_Key_Password=@prompt
content_copy
```
    Supply a password when prompted.
- If HTTPS private-key and public-certificate files are not available, configure HTTP instead:
  - Set the HTTP port by using the command .
```
hvrhubserverconfig HTTP_Port=4340
content_copy
```
    Port 4340 is recommended for Local Data Processing's use of HTTP protocol.
    Browser may give warnings that HTTP is insecure. These warnings must be ignored (until HTTPS is configured).
Set up the Local Processing Hub System, which requires connecting it to its repository database and initializing that database's repository tables. This can be done from a web browser (UI) or from the command-line (CLI).
- Setting up system from browser:
  1. Start the Local Processing Hub Server by using the command .
```
hvrhubserver -acs
content_copy
```
  2. In the web browser, connect to the URL shown (e.g. http://mynode:4340/) in the command hvrhubserver output above. The Local Processing Hub System will be running in a 'setup mode'. Once the system setup steps are completed, the Local Processing Hub System will automatically exit the 'setup mode'. For more information about setting up the Local Processing Hub System from browser, see .
- Setting up system from command-line (advanced usage). For more information about setting up the Local Processing Hub System from CLI, see .
Configure alerts. Local Data Processing can send alert notifications if a problem affects replication. Alerts can also be configured to be sent if the replication latency (the delay between capturing a change and delivering that change to the target) exceeds an SLA (Service Level Agreement).
Alerts are sent by a separate process called , which should be scheduled to run at a fixed frequency (e.g. every 10 minutes).
1. To check alerts every 10 minutes, create Windows Scheduled Tasks (for example, task is named HVR_Alert).
```
schtasks /create /sc minute /mo 10 /tn HVR_Alert /tr C:\fivetran\hvr_home\bin\hvralertmanager.exe
content_copy
```
  Alternatively, the Windows Scheduled Tasks can be created using the Windows GUI. Click here for the steps
  1. Open Task Scheduler. This can be accessed from Control Panel ▶ Administrative Tools
    Alternatively, Task Scheduler can be accessed by running (Winkey+r) taskschd.msc.
  2. Click Action ▶ Create Task
  3. In General tab, enter task Name, and optionally a task Description.
  4. In Actions tab, click New... to open New Action dialog.
  5. Browse and select the directory path for hvralertmanager.exe (available in HVR_HOME\bin) and click OK.
  6. In Triggers tab, click New... to open New Trigger dialog.
  7. Select the required frequency at which this task should be executed. For example, to execute this task every 10 minutes:
  8. Click OK in Create Task dialog.
2. To verify that is running correctly, check 10 minutes later that lines are being written to file alertmanager.out available in HVR_CONFIG\logs directory.