The process of connecting to databases like TMT, Squarerigger etc. involves installing 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:
Create a new read only user in your database
Download & Install the IR on your network
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 .
To connect to a database
Create a read-only database user that is restricted to the database that you are connecting to.
Test the database user by logging into "SQL Management Studio" to confirm the user is active.
We recommend 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.
Back in FleetOps, go to 'Settings' by clicking on the settings icon from the bottom of the navigation menu
Click 'Integrations' to see the list of connections.
Click the database that you want to connect to, for example, TMT
Download and install the Microsoft IR from the following location:
https://www.microsoft.com/en-us/download/details.aspx?id=39717. We recommend downloading the latest version.
Install the IR on a server that has access to the database server but do not install it on the database server itself.
The installation process will prompt you to enter an Authentication Key. The Key will be shown under 'Step two' on the right side of your FleetOps screen
Copy the key and paste it back into the Microsoft IR installation wizard. Click 'register' and you'll get a green tick confirming a secure link to the FleetOps platform has been confirmed.
Proceed to the next step in FleetOps and add the database connection details including the user credentials.
Click 'Save & check connection'
Once we have successfully connected, we will begin syncing the data from your database.
Note: If required you can schedule a call with our engineering team to guide you through the install process by emailing [email protected]. If possible, we recommend that the IR is downloaded and the database user is created before the call.
What's next
Still using the FleetOps v1/v2 interface? View the legacy version of this article.