Important
As of version 4.0, the MyGeotab API Adapter solution has been fully migrated to Data Model 2 (DM2). The original data model and the Data Optimizer have been deprecated and removed from the solution effective January 2, 2026.
Anyone still using the original data model and looking to upgrade may refer to the following sections in the now deprecated original guide:
Notes
- Self-contained deployments are packaged in zip files - the names of which are prefixed with "MyGeotabAPIAdapter_SCD_" followed by the target Runtime Identifier (e.g. "win-x64").
- If using SQL Server or Azure SQL for the adapter database, the SQLServer.zip file contains the scripts associated with this release.
- If using PostgreSQL for the adapter database, the PostgreSQL.zip file contains the scripts associated with this release.
Here are some videos to help get started quickly and augment the documentation below. While SQL Server is the database of choice in these videos, the processes are similar for PostgreSQL, so the videos are still relevant regardless of the database provider chosen.
▶️ How to Download the MyGeotab API Adapter (3:25)▶️ How to Set Up the MyGeotab API Adapter Database (4:20)▶️ How to Deploy and Configure the MyGeotab API Adapter Application (8:15)▶️ How to Start the MyGeotab API Adapter Application (2:15)▶️ How to Upgrade the MyGeotab API Adapter (7:11)
For more detailed information, refer to the official guide and presentation:
Upgrade Instructions
NOTE: This build includes changes to the schema of the adapter database.
- To upgrade an existing installation of the MyGeotab API Adapter solution from version 4.1.1 to version 4.1.2, see MyGeotab API Adapter — Upgrade Guide — from v4.1.1 to v4.1.2
Changes in This Release
For information on changes introduced in this and prior releases, refer to: Change Log - MyGeotab API Adapter - Data Model 2 (DM2)
Change Summary
Changes in this release are summarized below.
- Bug Fix: Resolved an issue with DatabaseMaintenanceService2 whereby Level 2 database maintenance may fail in some PostgreSQL environments where the geotabadapter_user lacks execute permissions on pgstattuple. Resolves Issue #25.
- Updated version to 4.1.2.0.
Feedback
Help us prioritize future efforts and better understand how the API Adapter is used! If you would like to provide any feedback about the MyGeotab API Adapter solution, please feel free to complete the 100% voluntary MyGeotab API Adapter - Usage Survey.