User Guide

EN - CS-CZ - DE-DE - ES-ES - ES-LATAM - FR-CA - FR-FR - IT-IT - JA-JP - KO-KR - NL-NL - PL-PL - PT-BR - SV-SE

February 2025



Introduction

The Geotab Data Connector is a tool designed for fleet managers to import curated data sourced from their own fleets into their preferred BI/visualization tool without having to manually leverage MyGeotab reports. Additionally, this tool allows fleet managers to customize their reports without the need for coding, unlike the MyGeotab SDK.

Additional Resources

Requirements

1. Valid MyGeotab credentials (database name, username, and password).
2. The Data Connector Add-In enabled in MyGeotab.
3. 1. You can check the Add-In status on the Data Connector Marketplace page.
   2. You can enable Data Connector directly from the Data Connector page in Mygeotab under Reports or Marketplace, or contact your Reseller if you don’t have access to Marketplace.
   3. The Data Connector page can be found under Reports on the side nav in MyGeotab. If the solution has not been installed you will see the option to do so and if it is installed you will see an ‘unlocked’ view of the page with the access URL links etc all available to be used.
3. One of the following supported BI/visualization tools:

✱ NOTE: The Geotab Data Connector officially supports only the latest version of the above tools, but will may work for some older versions as well. Issues experienced with previous iterations of these tools may not be eligible for support.

The Geotab Data Connector allows users to connect to their data using OData. In order to connect, you must authenticate with your MyGeotab credentials. Keep in mind that the access URL may differ based on your MyGeotab database.

! IMPORTANT: The above table only indicates that the connection method was officially tested with the Geotab Data Connector Add-In. Although some of the listed tools that are marked unsupported may provide support for OData, we cannot guarantee functionality when using a supported tool with an unsupported connection method.

Start with Dashboard Templates

Geotab provides dashboard templates for quick and impactful insights to accelerate your dashboard development. You can get started by using one of the sample dashboards that we provide by loading the dashboard, entering your MyGeotab credentials, verifying the Access URL, and refreshing the data. All of our templates can be found in the Geotab Data Connector Add-In. For more information on how to use the templates and a complete list of available templates, refer to the Template Guide.

Access

General access via OData protocol

Find Your Base Access URL

For Power BI and Excel users, you are able to use the unified access URL as both Power BI and Excel support server redirection.

! IMPORTANT: For Tableau users, the Data Connector needs to be accessed through an alternate access URL as Tableau does not support server redirection. The URL can be found in the Geotab Data Connector Add-In. The URL contains a specific serverNumber to be used for accessing the Data Connector.

Base Access URL

To get started, access the Geotab Data Connector Add-In page within MyGeotab to get the access URL needed for your respective BI tool:

Username: <MyGeotab Database Name>/<MyGeotab Username>

Password: <MyGeotab Password>

Specify Table and Date Range Filter on Access URL

For operational reporting, we recommend applying date range filters to specific tables/resources. Using date range filters on historical/date-based tables results in faster data returns due to the results being pre-filtered before being imported to the BI tool.Device

The date range filter applies to the local date/datetime (based on the time zone setting of each telematics device in MyGeotab).

We currently support two forms of date range filters: absolute and relative date ranges. We recommend using relative date ranges for typical dashboarding, and absolute date ranges for ad-hoc analyses.

When using date range filters, you must explicitly name the table name or resource.

Access URL

1. Simplified URL for Power BI and Excel: https://data-connector.geotab.com/odata/v4/svc/[tableName]?$search=<dateRange>
2. For Tableau-specific URLs - for databases on Data Connector server <serverNumber>: https://odata-connector-<serverNumber>.geotab.com/odata/v4/svc/[tableName]?$search=<dateRange>

Supported tables

Only historical/date-based tables can be used with date range filters. The following table/resource names support date-range filters:

1. VehicleKpi_Daily
2. VehicleKpi_Monthly
3. DriverKpi_Daily
4. DriverKpi_Monthly
5. FleetSafety_Daily
6. VehicleSafety_Daily
7. DriverSafety_Daily
8. FaultMonitoring_Daily

Absolute date range

We recommend using an absolute date range for ad-hoc or static analyses. When using an absolute date range, data is pre-filtered on the server for the specified date range when returning results into the BI.

Method 1: specifying a from and to date

1. This filters for data records that have a local date between the specified from and to date.
2. Syntax for dateRange: from_yyyy-MM-dd_to_yyyy-MM-dd

3. Method 2: specifying only a from date

3. This filters for data records that have a local date between the specified from date until the newest available date.
4. Syntax for dateRange: from_yyyy-MM-dd

Some examples are listed below. For Power BI and Excel users, the access URL’s subdomain should be simplified to

https://data-connector.geotab.com.

Relative date range

We recommend using relative date ranges for a better experience with regularly-refreshed dashboards. When using a relative date range, data is pre-filtered on the server for the specified rolling window of time, meaning your dashboards will always display the most recent information. Relative date ranges allow you to get, for example, daily vehicle level data for the most recent 30 days, hourly level data for the most recent 14 days, and so on.

Supported position keywords: Controls whether to include an impartial date part/interval.

1. this (these)
2. last

3. Supported date parts: The date part or interval that controls the filtering of data.

3. day
4. week
5. month
6. year

Syntax for dateRange: <positionKeyword>_<number>_<datePart>

1. Note that when the <number> argument is 1, it can be completely omitted and changed to <positionKeyword>_<datePart> for convenience

Listed below are some sample generic, commonly-used relative date range filters. For Power BI and Excel users, the access URL’s subdomain should be simplified to https://data-connector.geotab.com.

Using Power BI

When using the Data Connector with Power BI, data obtained from the connector is stored and cached in the local machine within the Power BI file. We encourage you to refresh your page on a daily basis to access the latest data.

1. Under the Data ribbon tab, select Get data.
2. Select OData Feed. If you are unable to find OData feed from this selection, select More… under the data sources, select Other from the left navigation menu, and then select OData Feed.
3. Select the Basic radio button.
4. Under URL, paste in the Access URL from General access via OData protocol that corresponds to your database’s Data Connector Server and then click OK.
5. When prompted for authentication, select Basic from the left navigation menu.
6. For the credentials, use the following:
7. 1. User name: <MyGeotab Database Name>/<MyGeotab Username>
   2. Password: <MyGeotab Password>
   3. Select which level to apply these settings to: do not modify this
7. Click Connect to view the available data resources.
8. From the Data Navigator, select all the relevant tables and resources that you would like to import.
9. Click Load to import the data as-is, or click Transform Data to transform and alter the data before loading it into the Power BI data model.

Using Excel

When using the Data Connector with Excel, data obtained from the connector is stored and cached in the local machine within the Excel workbook file. We encourage you to refresh your page on a daily basis to fetch updated data.

1. Under the Data ribbon tab, select Get Data.
2. Under From Other Sources, select OData Feed.
3. Select the Basic radio button.
4. Under URL, paste the Access URL from General access via OData protocol that corresponds to your database’s Data Connector Server and then Click OK.
5. When prompted for authentication, select Basic from the left navigation menu.
6. For the credentials, use the following:
7. 1. User name: <MyGeotab Database Name>/<MyGeotab Username>
   2. Password: <MyGeotab Password>
   3. Select which level to apply these settings to: do not modify this
7. Click Connect to view the available data resources.
8. From the Data Navigator, select all the relevant tables and resources that you would like to import
9. Click Load to import the data as-is, or press Transform Data to transform and alter the data before loading it into the Excel data model.

Using Tableau

When using the Data Connector with Tableau, data obtained from the connector is stored and cached in the local machine as a Tableau extract file. We encourage you to refresh the underlying data sources on a daily basis to fetch updated data.

For new Tableau Workbooks

1. Under the Connect navigation pane on the left-hand side, locate To a Server and select More…
2. Select OData from the expanded list of server sources.
3. Under Server, paste in the Access URL from General access via OData protocol that corresponds to your database’s Data Connector Server.
4. Under Authentication, select Username and Password.
5. For the credentials, use the following:
6. 1. Username: <MyGeotab Database Name>/<MyGeotab Username>
   2. Password: <MyGeotab Password>
6. Click Sign In to view the available data resources.
7. From the left navigation menu under Table, drag the relevant table or resource that you would like to import into the “Drag tables here” icon.
8. Now that the workbook is created, follow the steps from For existing Tableau Workbooks to import any other tables.

For existing Tableau Workbooks

1. Under the Menu bar at the top, select Data.
2. Select New Data Source.
3. Under the Connect screen, locate To a Server and then select More…
4. Select OData from the expanded list of server sources.
5. Under Server, paste in the Access URL from General access via OData protocol that corresponds to your database’s Data Connector Server.
6. Under Authentication, select Username and Password.
7. For the credentials, use the following:
8. 1. Username: <MyGeotab Database Name>/<MyGeotab Username>
   2. Password: <MyGeotab Password>
8. Click Sign In to view the available data resources.
9. From the left navigation menu under Table, drag the relevant table or resource that you would like to import into the “Drag tables here” icon.

Troubleshooting

General

I am able to connect to the Data Connector using the correct credentials. Why is it that I can see the data schema, but not any data (or data for a specific vehicle or device)?

Ensure that you have the appropriate view permission for the vehicle/device on your MyGeotab account. If you do have the appropriate permissions enabled on your MyGeotab account and the data is still blank, it could mean that no activity for the vehicle/device was recorded for the specified time period.

What is Rate limiting?

The Rate limiting feature protects the stability of the Data Connector. There is a limit to the number of requests sent to the Data Connector in a short period of time. If you reach the limited number of requests, you will need to wait before refreshing the data sources to your dashboard.

Different tables may have different rate limiting, but the general rate limiting is set to 100 requests per user, per minute.

I am on an older version of Power BI/Tableau/Excel. Can I still use the Data Connector?

As long as Power BI/Tableau/Excel supports getting data through the OData feed, you should be able to use the Data Connector. However, the Data Connector is only tested on the latest versions of Power BI, Tableau, and Excel.

I am using other unlisted BI tools. Can I still use the Data Connector?

Currently, the Data Connector only officially supports Power BI, Excel, and Tableau. We do not offer official support to other BI tools as we cannot guarantee the resulting behavior. We are looking to expand our support to other BI tools in the future. It is possible to connect via the OData protocol to many other BI tools, but Geotab cannot guarantee compatibility at this time.

Where is VIN (Vehicle Identification Number) populated from?

VIN data presented in Vehicle KPI as well as Vehicle Metadata originate from the VIN field on the asset page from Version 2 of the Data Connector onward. Usually, this is the VIN read by the telematics device from the vehicle. However, if the VIN field was manually edited on the asset page, both Vehicle KPI as well as Vehicle Metadata tables will reflect the user-inputted VIN value. If you have certain vehicles that do not report VIN through the diagnostic port in the vehicle, work with your Reseller and Geotab resources to open a Vehicle Data Request (VDR).

I am not seeing Odometer readings for some vehicles. Why is this happening?

This can happen when the vehicle does not communicate odometer data to the telematics device through the diagnostic port connection. The Data Connector product does not currently capture manually-entered/edited odometer entries in MyGeotab. If you have certain vehicles that do not report odometer through the diagnostic port in the vehicle, work with your Reseller and Geotab resources to open a Vehicle Data Request (VDR).

Why do I not see some fields relating to EV range and state of health in the monthly Vehicle KPI table?

For EV range and state of health related fields, we only display available information if the last-observed VIN during the month is an EV. The displayed EV range and state of health data reflects the latest estimate within the local calendar month.

I am using SAML/SSO to log in to MyGeotab. Can I authenticate using the same credentials in Data Connector?

No. Currently, Data Connector only supports basic authentication. You must either switch your authentication type from SAML to basic authentication, or create a new account with basic authentication in MyGeotab to connect to the Data Connector.

Power BI

Why am I getting an “Unable to connect: We encountered an error while trying to connect. Details: OData: We were unable to detect required payload information” error message?

This is a known Power BI issue caused by an empty response payload due to lack of viewing permission to the database’s data. Ensure that you have the appropriate view permission for the vehicle/device setup on your MyGeotab account.

How do I change authentication or user?

To change credentials used for the Data Connector server:

1. Select File under the ribbon menu, and then select Options and settings.
2. Click Data source settings.
3. Select the relevant Data Connector access URL and click the Edit Permissions button.

You should now be presented with an Edit button under Credentials. Users have the ability to edit credentials for a single PBIX file using ‘Data sources in current file’ or multiple pbix files saved on the same local machine using ‘Global permissions’. Note that the credentials used are saved locally, and are not saved in each PBIX file.

The remote server returned an error: (400) Bad Request

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

In addition, please ensure that the Access URL is entered correctly. There could be a misconfigured query option after the $search part of the URL, such as the date format or the date range in the query option arguments.

The remote server returned an error: (401) Not Authorized

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

The remote server returned an error: (404) Not Found

Double-check the Access URL used to access the Data Connector. The error indicates that the requested resource or table does not exist.

The remote server returned an error: (406)

Double-check the Access URL used to access the Data Connector. The error indicates that the provided Data Connector Server does not match your MyGeotab database

OData: Request failed: The remote server returned an error: (412)

This error indicates that the user is not subscribed to the Geotab Data Connector solution. Refer to Requirements for instructions on how to subscribe to the Add-In.

OData: Request failed: The remote server returned an error: (416)

This error indicates that the request for data is too large, and exceeds the limits for the Data Connector. Consider reducing the amount of data returned by using narrower date range filters.

OData: Request failed: The remote server returned an error: (429)

This error indicates that you have sent too many requests to the Data Connector in a short period of time. This is a feature to protect the stability of the Data Connector. Wait a few minutes before refreshing the data sources to your dashboard.

Different tables may have different rate limits, but the general limit is 100 requests per user per minute.

OData: Request failed: The remote server returned an error: (500)

The Data Connector service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

OData: Request failed: The remote server returned an error: (503)

MyGeotab authentication service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

OData: The Property {0} does not exist on type {1}. Make sure to only use a property name that is defined by the type or mark the type as open type.

There is a change in the Data Connector’s metadata. Please clear the data cache from within the Get Data prompt. Navigate to the File Ribbon tab, click Options and settings, then click Options. In the new Options dialog, under the left navigation pane and right below Global, select Data Load. In the right main pane, scroll down to the section that says Data Cache Management Options and click Clear Cache. You can now restart Power BI before refreshing the data connections.

Excel

[DataFormat.Error] We cannot return the data produced by this query because of its complexity.

This error indicates that you have sent too many requests to the Data Connector in a short period of time. This is a feature to protect the stability of the Data Connector. Wait a few minutes before refreshing the data sources to your dashboard.

The remote server returned an error: (400) Bad Request

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

In addition, please ensure that the Access URL is entered correctly. There could be a misconfigured query option after the $search part of the URL, such as the date format or the date range in the query option arguments.

The remote server returned an error: (401) Not Authorized

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

The remote server returned an error: (404) Not Found

Double-check the Access URL used to access the Data Connector. This error indicates that the requested resource or table does not exist.

The remote server returned an error: (406)

Double-check the Access URL used to access the Data Connector. The error indicates that the provided Data Connector Server does not match your MyGeotab database.

OData: Request failed: The remote server returned an error: (412)

This error indicates that the user has not subscribed to the Geotab Data Connector solution yet. Refer to Requirements for instructions on how to subscribe to the Add-In.

OData: Request failed: The remote server returned an error (416)

This error indicates that the request for data is too large, and exceeds the limits for the Data Connector. Consider reducing the amount of data returned by using narrower date range filters.

OData: Request failed: The remote server returned an error: (429)

This error indicates that you have sent too many requests to the Data Connector in a short period of time. This is a feature to protect the stability of the Data Connector. Wait a few minutes before refreshing the data sources to your dashboard.

Different tables may have different rate limits, but the general limit is 100 requests per user per minute.

OData: Request failed: The remote server returned an error: (500)

The Data Connector service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

OData: Request failed: The remote server returned an error: (503)

MyGeotab authentication service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

OData: The Property {0} does not exist on type {1}. Make sure to only use a property name that is defined by the type or mark the type as an open type.

There is a change in the Data Connector’s metadata. Please clear the data cache from within the Get Data prompt. Navigate to the Data Ribbon tab, then click Get Data. Under Get Data, select Query Options. In the new Query Options dialog, under the left navigation pane select Data Load. Scroll down to the section that says Data Cache Management Options and click Clear Cache. You can now restart Excel before refreshing the data connections.

Tableau

Unable to access OData URL {0} with server response 400

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

In addition, please ensure that the Access URL is entered correctly. There could be a misconfigured query option after the $search part of the URL, such as the date format or the date range in the query option arguments.

Unable to access OData URL {0} with server response 401

Double-check the credentials used to access the Data Connector. Ensure the Username is in the form <MyGeotab Database Name>/<MyGeotab Username>.

Unable to access OData URL {0} with server response 404

Double-check the Access URL used to access the Data Connector. The error indicates that the requested resource or table does not exist.

Unable to access OData URL {0} with server response 406

Double-check the Access URL used to access the Data Connector. The error indicates that the provided Data Connector Server does not match your MyGeotab database.

Unable to access OData URL {0} with server response 412

This error indicates that the user has not subscribed to the Geotab Data Connector solution yet. Subscribe to the solution as mentioned in Requirements before requesting the data.

Unable to access OData URL {0} with server response 416

This error indicates that the request for data is too large, and exceeds the limits of the Data Connector. Consider reducing the amount of data returned by using narrower date range filters.

Unable to access OData URL {0} with server response 429

This error indicates that you have sent too many requests to the Data Connector in a short period of time. This is a feature to protect the stability of the Data Connector. Wait a few minutes before refreshing the data sources to your dashboard.

Unable to access OData URL {0} with server response 500

The Data Connector service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

OData: Request failed: The remote server returned an error: (503)

MyGeotab authentication service is temporarily unavailable. Try again later, and if the error persists, contact customer support.

Unable to connect to the server: Deadline Exceeded

The error indicates that your connection has timed out. Consider reducing the amount of data returned by using narrower date range filters.