The first step in Onboarding for FleetOps is to connect with your locally hosted DB2 TMS database.

The process will involve you installing Microsoft Data Factory on a server in your network to periodically query and sync data from your TMS database to the FleetOps data warehouse.

Note: All traffic is outbound and therefore no changes to your firewall is required. All data is encrypted in transit and at rest.

We support the industry’s leading TMS & IT Systems so this should be painless, however, you can always request support and have someone guide you through the installation by emailing support@fleetops.com.

For TMW TruckMate users

The FleetOps platform securely mirrors data from your on-premise database using Microsoft's Integration Runtime (IR). The IR is a Windows Service that creates a secure link to transfer data between your network and the FleetOps platform.

To complete this install you will need to:

  • Signup to FleetOps - you will be sent an invite

  • Download & Install the IR on a server inside your network (NOT your DB server)

  • Create a new user in Active Directory (AD)

  • Create a new user in TruckMate

Server Requirements
As of June 2024, the Microsoft IR requires a 64-bit Operating System with .NET Framework 4.7.2 or above. The recommended configuration for the Integration Runtime (Self-hosted) machine is 2 GHz, 4 Core CPU, 8 GB Memory and 80 GB disk. The latest requirements can always be found on the Microsoft IR download site .

Getting Started

The install process typically takes about 15-30 minutes to complete.

Note: If required, you can schedule a call with our engineering team to guide you through the install process by emailing support@fleetops.com. If possible, we recommend that the IR is downloaded and the database user is created before the call.


  1. Create a new user

    1. Create a new user in Active Directory (AD) e.g. FleetOps

    2. Create a new user in TruckMate with the same name as the one in AD

    3. Assign the TruckMate user to a TruckMate group that has read-only permission to the TruckMate tables.

    4. For more details on User management in TruckMate, refer to the following documentation.

  2. Download and install the Microsoft IR from the following location:

    1. https://www.microsoft.com/en-ie/download/details.aspx?id=39717. We recommend to download the latest version.

    2. Install the IR on a server that has access to the database server but do not install it on the database server itself.

    3. The installation process will prompt you to enter an Authentication Key. The Key will be shown as part of the FleetOps Onboarding process (step 4a below).

  3. Activate your FleetOps account - as part of onboarding you will have received an invite to sign up for FleetOps. If this has not been received please email support@fleetops.com or if there is an existing FleetOps administrator for your organization they can send you an invite. Once you sign up, you will be presented with an Onboarding wizard.


    Click on the link below to learn how to sign up to FleetOps

  4. Start the 'Integrate with your TMS' onboarding step


    1. Once you reach the step that displays your Authentication Key, copy the key and paste it back into your local Microsoft IR installation wizard (step 2). Click on 'register' and you should receive a green tick confirming a secure link to the FleetOps platform has been confirmed.



    2. Proceed to the next Onboarding step in the FleetOps wizard and add the database connection details including the user credentials from step 1.

FAQ (possible errors and fixes)

Q: FleetOps reports an error when I enter the DB2 database connection details

A: This typically happens when details are not entered correctly:

  • Confirm that the AD and TruckMate users have the identical name.

  • When logging in with DB2, the password used is the NT password.

  • Ensure that the TruckMate user is assigned to a group.