Installing Data Exchange Runtime Service

To install the Runtime Service on your system

  1. Run the Data Exchange Setup using the Run as administrator option.

    The Unisys Data Exchange <version_number>- Setup Wizard appears.

  2. Click Install Windows component.

    The Data Exchange Management Studio (DEMS) Connection Settings page appears.

  3. Provide the following details:

    • DEMS Host: The host name of the machine where you have installed DEMS. If you have used a non-default port, then enter the host name in the format Hostname:Port.

    • Environment: The environment in which you want to install this component.

  4. Click Next.

  5. Click the Runtime Service icon.

    The Unisys Data Exchange Runtime Service Setup page appears.

  6. Click Next.

    The Prerequisite Check page appears.

  7. Select the Data Manager type according to your transformation source and click Next.

    • If the required software is not installed for the selected platform, an error message saying “Prerequisite Check Failed” appears.

      1. Cancel the Runtime Service installation.

      2. Install the required software and begin the Runtime Service installation from start.

    • If the prerequisite check passes, the SQL Server Instance Configuration page appears.

  8. In the SQL Server Instance Configuration page

    1. Type the name of the SQL server instance in the SQL Server box.

      The Runtime Service connects to this server and creates the Tracking DB called UnisysDExchTrackingDB<version number>, which maintains information, such as status of data that is processed, audit sequence numbers, and database connection details.

      Notes:

      • If you connect to a remote SQL instance, the application user account may not be created successfully, as the application user account can be created only in the local machine and it will not be able to connect to the remote SQL instance.

      • Do not perform any operation on the tracking database other than backing it up.

      • Do not rename or move this database at any point in time, as it may result in creation of duplicate data in the transformation targets.

    2. Select one of the following authentication methods for the Runtime Service to connect to the SQL database:

      • Windows Authentication: To connect to the SQL database using your Windows credentials.

        Note: Since the Runtime Service is running under the system account "NT AUTHORITY\SYSTEM" in the SQL server, ensure that "NT AUTHORITY\SYSTEM" is assigned with the “sysadmin” role.

      • SQL Authentication: To connect to the SQL database using the credentials that you received from your SQL server administrator. In this case, you must provide your credentials in the relevant fields.

        Note: To choose "SQL Authentication", you must have the SQL credentials specific for Data Exchange created in the SQL Server. The user name must have the sysadmin role in the SQL Server.

         Warning

        While creating the credentials using the SQL Server Management Studio, clear the Enforce password expiration check box in the Login-New window, because once the password expires in the SQL Server, the Runtime Service cannot connect to the SQL Server. You do not have any option of using the new password in the Runtime Service unless you reinstall it.

    3. Select Secure Connection if you want to enable secure connection to the Tracking DB.

      Notes:

    4. Click Test Connection to ensure that a connection is established between the Runtime Service and your SQL Server instance.

      A green tick mark appears indicating success.

      Note: You cannot proceed unless a connection is established.

  9. Click Next.

    If you are installing another (higher) version of the Runtime Service, and a tracking database of a lower version exists, then the Tracking Database Information page appears. Select one of the following options:

    • Initialized data: Select this to create a new tracking database with initialized data.

    • Data migrated from the Tracking DB of: Select this to create a new database, and then copy the data from the selected database.

  10. Click Next.

    If you are using Windows Authentication, then the Application User Credentials page appears. Select one of the following options:

    • Create a New Application User Account

      Note: The user account you create must be new. If you create an account with the same name as a previously existing account, the installation can fail. This is because the old account might still be in use by a system resource. If you need to use the same name, you must restart the machine and reinstall Runtime Service.

    • Select an Application User from Existing Accounts

    • Use System Account as Application User Account

    If you create the application user account, then the Runtime Service runs under this account, thereby enhancing security. By default, it runs under the Local System account.

    If you select any of the first two options, then you need to enter the appropriate information in the page that appears subsequently. If you select the third option, you can install the Runtime Service with the default “Local System” account.

    Notes:

    • If you are using Windows Authentication, then the application user account is automatically provided the privilege to read and write the Tracking DB.

    • For the application user account to read the source or modify the target SQL Server database, you must assign the “db_reader“ or “db_datawriter" or higher privilege to it in the SQL Server Management Studio.

      If the source or the target SQL Server database and the Tracking DB are in different SQL Server instances, then you must first create a login in the SQL Server Management Studio for the application user account.

  11. Click Next.

    The Set TCP Port page appears . It displays

    • The default port number (9299) used to connect from the Runtime Administration to the Runtime Service.

    • The default port number (9303) used to connect from the OS 2200 Agent to the Runtime Service.

    Note: Do not change the default port number if it is available. If you change the port number, you need to manually set the port number for other components to connect to the Runtime Service.

  12. Click Next.

    The Destination Folder page appears, displaying the default location where the Runtime Service will be installed.

  13. Click Next.

    The Ready to install Unisys Data Exchange Runtime Service page appears.

  14. Click Install.

    The Installing Unisys Data Exchange Runtime Service page appears, displaying the progress of the installation.

  15. Click Finish to finish the installation.

At any point during the installation, you can cancel the installation by clicking Cancel. You can go back to the previous screen by clicking Back on all the screens except the installation screen.