Installing DSS Hub on Windows using Zip File - DSS 6 | Data Source Solutions Documentation

Documentation: Installing DSS Hub on Windows using Zip File - DSS 6 | Data Source Solutions Documentation

Installing DSS Hub on Windows using Zip File

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

For installing the DSS Hub on Windows using installer, see Installing DSS Hub on Windows using Installer.

For installing DSS Agent on Windows using installer or zip file, see Installing DSS Agent on Windows using Installer or Installing DSS Agent on Windows using Zip File 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 DSS 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 Hub Disk Requirements.

  • Compatibility
    Check whether the DSS version is compatible with the operating system and DBMS. Refer to the relevant Supported Platforms section or read the COMPATIBILITY section in the release notes (available under the Downloads tab in the Data Source Solutions dashboard).

  • Installation file
    DSS Hub System installation file for Windows (e.g. datasourcesolutions-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip). This file can be downloaded from the Downloads tab in the Data Source Solutions dashboard. For more information, see Downloading DSS.

  • Database for DSS repository
    DSS 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 Repository Database.

  • Access to source and target locations
    For the DSS 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 Source and Target Requirements.

  • Perl version 5.6 or higher must be installed. If Perl is installed after the installation of DSS Hub System, then the hub server service must be destroyed and recreated.

  • Windows user account privileges.

    • Elevated user account privilege is required for running the DSS Hub System executable/installer. Normally this means the user must supply an administrator password interactively.

    • The user account (e.g., datasourcesolutions) that will operate the DSS Hub System must have the Log on as a service policy enabled.

      Click here for the steps to configure the user policy

      User account policies can be managed using the Windows Local Security Policy console accessible from Control Panel ▶ Administrative Tools. Alternatively, you can use the secpol.msc command to open this console directly. For more information about enabling this policy, refer to the Microsoft documentation.

      1. In the Local Security Policy window, expand Local Policies and click User Rights Assignment.
      2. Double-click the Log on as a service policy available in the list of policies on the right pane.
      3. In the Log on as a service Properties dialog, click Add User or Group to display the Select Users, Computers, Accounts, or Groups dialog.
      4. In the Enter the object names to select field, enter the user account name that requires this policy, and click OK.
      5. Click OK.

Install Steps

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

  1. Configure the environment variables DSS_HOME, DSS_CONFIG, and DSS_TMP for your operating system. Each of these environment variables should be pointed to the installation directories - dss_home, dss_config, and dss_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.

```plaintext
setx DSS_HOME C:\datasourcesolutions\dss_home
```
```plaintext
setx DSS_CONFIG C:\datasourcesolutions\dss_config
```
```plaintext
setx DSS_TMP C:\datasourcesolutions\dss_tmp
```
```plaintext
set DSS_HOME=C:\datasourcesolutions\dss_home
```
```plaintext
set DSS_CONFIG=C:\datasourcesolutions\dss_config
```
```plaintext
set DSS_TMP=C:\datasourcesolutions\dss_tmp
```

Also, add the executable directory path (e.g **C:\\datasourcesolutions\\dss_home\\bin**) to the environment variable **PATH**.

```plaintext
setx PATH "%PATH%C:\datasourcesolutions\dss_home\bin"
```
```plaintext
set PATH=%PATH%;C:\datasourcesolutions\dss_home\bin
```

<details><summary>Alternatively, environment variables can be configured using Windows GUI.</summary>

1.  Navigate to **Control Panel ▶ System and Security ▶ System ▶** **Advanced system settings**

    <div class="callout callout-note">

Alternatively, use the command sysdm.cpl to open System Properties.

2.  In **Advanced** tab, click **Environment Variables...**

    ![SC-Dss-Install-WindowsZip_SystemProperties.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_SystemProperties.webp)

3.  In the section **System variables** or **User Variables for** *user_name*, click **New**.  
    1.  Enter **Variable name** (e.g, **DSS_HOME**) and **Variable value** (e.g, **C:\\datasourcesolutions\\dss_home**).  
        ![SC-Dss-Install-WindowsZip_NewUserVariable.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_NewUserVariable.webp)  
    2.  Click **OK**.
    3.  Repeated the above steps for each environment variable.

4.  Add the executable directory path (e.g **C:\\datasourcesolutions\\dss_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...**.  
        ![SC-Dss-Install-WindowsZip_EnvironmentVariables.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_EnvironmentVariables.webp)  
    2.  Click **New** and enter the path for the executable.  
        ![SC-Dss-Install-WindowsZip_EditEnvVariable.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_EditEnvVariable.webp)  
    3.  Click **OK**.

</details>
  1. Create the installation directory - dss_home (e.g. C:\datasourcesolutions\dss_home).

    md %DSS_HOME%
    
  1. Uncompress (unzip) the installation file (e.g. datasourcesolutions-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip) into the dss_home directory.

    cd %DSS_HOME%
    
    tar -xf C:\Users\Admin\Downloads\datasourcesolutions-6.1.0_21-hub_and_agent-windows-x64-64bit_ga_patch.zip
    
    Alternatively, files can be uncompressed using the 'Extract All' option in Windows GUI.

    SC-Dss-Install-WindowsZip_ExtractAll.webp

  2. Configure the TCP listening port on which the DSS 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 - dss_config, etc, cert.

        md %DSS_CONFIG%
        
        md %DSS_CONFIG%\etc
        
        md %DSS_CONFIG%\etc\cert
        
      2. Copy the private-key and public-certificate files into the cert directory, and rename them as dsshubserver.priv_key, dsshubserver.pub_cert respectively.

        copy mycert.priv_key %DSS_CONFIG%\etc\cert\dsshubserver.priv_key
        
        copy mycert.pub_cert %DSS_CONFIG%\etc\cert\dsshubserver.pub_cert
        
      3. Set the HTTPS and HTTP ports by using the command dsshubserverconfig.

        dsshubserverconfig HTTPS_Port=4341 HTTP_Port=4340
        
    4.  If the private-key is encrypted, optionally, you can set password for the private-key.

        ```plaintext
        dsshubserverconfig HTTPS_Private_Key_Password=@prompt
        ```

        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 [**dsshubserverconfig**](/docs/dss6-command-line-interface-command-reference-dsshubserverconfig).

        ```plaintext
        dsshubserverconfig HTTP_Port=4340
        ```

        <div class="callout callout-note">
  1. Set up the DSS 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 DSS Hub Server by using the command dsshubserver.

        dsshubserver -acs
        

Unlike the installer-based installation, the ZIP file installation does not automatically configure the DSS Hub Server process to start after a system reboot. You must manually configure auto-start for this process. For instructions, see Configuring DSS Auto-Start on Windows.

    2.   In the web browser, connect to the URL shown (e.g. **http://mynode:4340/**) in the command **dsshubserver** output above. The DSS Hub System will be running in a 'setup mode'. Once the system setup steps are completed, the DSS Hub System will automatically exit the 'setup mode'. For more information about setting up the DSS Hub System from browser, see [Setting up DSS Hub from Browser](/docs/dss6-install-and-upgrade-configure-hub-setting-up-hub-from-browser).
-   Setting up system from command-line (advanced usage). For more information about setting up the DSS Hub System from CLI, see [Setting up DSS Hub from CLI](/docs/dss6-install-and-upgrade-configure-hub-setting-up-hub-from-cli).  
  1. Configure alerts. DSS 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 dssalertmanager, 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 DSS_Alert).

      schtasks /create /sc minute /mo 10 /tn DSS_Alert /tr C:\datasourcesolutions\dss_home\bin\dssalertmanager.exe
      
      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**  
        ![SC-Dss-Install-WindowsZip_CreateTask.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_CreateTask.webp)

    3.  In **General** tab, enter task **Name**, and optionally a task **Description.**  
        ![SC-Dss-Install-WindowsZip_CreateTask_General.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_CreateTask_General.webp)

    4.  In **Actions** tab, click **New...** to open **New Action** dialog.

    5.  Browse and select the directory path for **dssalertmanager.exe** (available in **DSS_HOME\\bin**) and click **OK**.  
        ![SC-Dss-Install-WindowsZip_CreateTask_EditAction.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_CreateTask_EditAction.webp)

    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:  
        ![SC-Dss-Install-WindowsZip_CreateTask_NewTrigger.webp](/static/docs/docs/dss6/install-and-upgrade/install/hub/installing-hub-on-windows-using-zip-file/_assets/SC-Dss-Install-WindowsZip_CreateTask_NewTrigger.webp)

    8.  Click **OK** in **Create Task** dialog.

    </details>

2. To verify that [**dssalertmanager**](/docs/dss6-command-line-interface-command-reference-dssalertmanager) is running correctly, check 10 minutes later that lines are being written to file **alertmanager.out** available in **DSS_CONFIG\\logs** directory.

For the steps to configure connection via proxy server, see section Configuring Connection via Proxy Server on Windows.

See Also