If you are migrating to another server, this essentially means repeating the initial installation process to ensure the data transfer continues to the FleetOps platform.

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 FleetOps. All traffic is outbound and therefore no changes to your firewall is required. All data is encrypted in transit and at rest.

This 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.

To complete this install you will need to:

  • Download & Install the IR on your network

  • Create a new user in your database

  • Grant SELECT permission to the new user

  • Add the new connection details into the FleetOps system

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.

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. The latest requirements can always be found on the Microsoft IR download site .


What is the IR

As FleetOps, we leverage Microsoft's Self-Hosted Integration Runtime (IR) to establish a secure data mirroring connection between your on-premise database and our FleetOps platform.

The Self-Hosted Integration Runtime serves as a trusted, secure agent installed within your private network infrastructure. This agent enables our FleetOps solution to safely access and replicate data from your on-premise databases without exposing your internal systems to external networks.

By deploying this integration runtime, we create a secure bridge that allows FleetOps to mirror your data to our cloud-based platform while maintaining your existing security protocols and firewall configurations. The IR operates entirely within your controlled environment, ensuring that sensitive data never traverses unsecured channels."


Installation Process

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

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

    1. Test the database user by logging into "SQL Management Studio" to ensure that the user is active.

    2. We would prefer that the "SQL Server Login Password Expiration" option is not enabled (this may be enabled by default when creating a user). If this is enabled, the integration will stop working once it expires.

  2. Download and install the Microsoft IR from the following location:https://www.microsoft.com/en-ie/download/details.aspx?id=39717. We recommend to download the latest version.

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

  4. The installation process will prompt you to enter an Authentication Key. You can obtain your Authentication key from FleetOps here: https://app.fleetops.com/settings/connectors/ir-guide

  5. Copy the key and paste it back into the 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.

  6. Go the Connector screen in your FleetOps system: https://app.fleetops.com/settings/connectors. You can then pick your TMS from the list and update the credentials to the new server, user and password. 


FAQ (possible errors and fixes)


Q: FleetOps reports an error when I enter the SQL Server connection details

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

  • If using Integrated Security (Windows Authentication) for connecting to the database, ensure that the user name is entered in the form of domain\user.

  • If the database instance is configured to use a non-default port number, the hostname and port should be entered in the following format: hostname,port_number.


Q: We are changing servers. What do I need to do to do with the IR.

A: If you are changing servers, you will need to:

  • Install the IR onto the new server.
  • Enter the Authentication key.
  • Uninstall the IR on the old server so that the only active connection is the new server.

Q: How do I access the IR application on my server?

A: To access the Integration Runtime (IR) on your server you need to find the Microsoft Integration Runtime Configuration Manager in your server using the Search Bar at the bottom left of your screen. See below:

Image Placeholder

From this application you have multiple actions you can take from Troubleshooting Problems with the IR and testing you connection to make sure the IR is connected.