Skip to main content

Integrate McLeod LoadMaster or TMW Suite TMS

How to connect your locally-hosted McLeod LoadMaster or TMW Suite SQL Server TMS to FleetOps.


​

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

You'll install Microsoft Data Factory on a server inside your network. It queries your TMS database on a schedule and syncs the data to the FleetOps warehouse.
​

Note: All traffic is outbound, so no firewall changes are needed. Data is encrypted in transit and at rest.
​

We support every major TMS, so most installs are quick. If you'd like help, email [email protected].
​

For TMW Suite and McLeod users
​

FleetOps mirrors data from your on-premise database using Microsoft's Integration Runtime (IR), a Windows Service that builds a secure link between your network and FleetOps.
​

To complete this install you will need to:
​

  • Sign up to FleetOps, we'll send you an invite
    ​

  • Download & Install the IR on your network
    ​

  • Create a new user in your database
    ​

  • Grant SELECT permission to the new user
    ​

Server Requirements
​

As of January 2022, 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. Find the latest requirements on the Microsoft IR download site .
​


​

Getting Started

Most installs take 15–30 minutes.
​

Note: If you'd like a guided install, email [email protected] and we'll book time with our engineering team. Ideally, download the IR and create the database user before the call.
​


​

  1. Create a database user, with SELECT permission, that is restricted to the [McLeod/TMW] database.
    ​

    1. Test the user by signing into SQL Management Studio and confirming the user is active.
      ​

    2. We recommend disabling SQL Server Login Password Expiration for this user (it may be on by default). If the password expires, the integration stops working.
      ​

  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 downloading the latest version.
      ​

    2. Install the IR on a server with network access to the database server, not on the database server itself.
      ​

    3. The installer asks for an Authentication Key. You'll see the key during FleetOps onboarding (step 4a below).
      ​

  3. Activate your FleetOps account. You'll get an invite to sign up as part of onboarding. If it hasn't arrived, email [email protected] or ask your FleetOps admin to send one. Once you sign up, an Onboarding wizard appears.
    ​

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

    Sign up to FleetOps
    ​


    ​

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

    Start the 'Integrate with your TMS' onboarding step


    ​

    1. When the Authentication Key step appears, copy the key and paste it into the Microsoft IR installer (step 2). Click Register. A green tick confirms the secure link to FleetOps.
      ​

      Once you reach the step that displays your Authentication Key, copy the key and paste it back into the


      ​

    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 SQL Server connection details
​

A: This usually means a detail is off:
​

  • If you're using Integrated Security (Windows Authentication), enter the user name as domain\user.
    ​

  • If the database uses a non-default port, enter the hostname and port as hostname,port_number.
    ​


​

What's next

Still using the FleetOps v1/v2 interface? View the legacy version of this article.

Did this answer your question?