mJobTime

Post date: Jan 24, 2020 10:42:59 PM

Author: Eric Vasbinder

Applicable ERPs

• Vista

Logistics

Support Status:  APPROVED

Integration Methods:

• VISTA:  

  • For Master Data Export from Vista to mJobTime

    • Direct ODBC - SQL Service account required (always required for Direct ODBC)

  • For Time Import into Vista

    • CSV export files from mJobTime; Manual Import into Vista using IM Import form

Connection Methods:

• VISTA:  

  • TLS Database Endpoint (TLS VPN) (PREFERRED) to Third Party

Hosted:  NO

Hosting Location:  Third Party or on-premise

Additional Charge:  NO

Vendor URL:    https://mjobtime.com/

Product Use Case

When customers wish to provide time keeping and tracking for their field crews.

Similar Products

This time keeping solution is similar to and has overlap with a number of solutions such as Trimble's Field Management, B2W Track, About Time, and others.

ERP Connection Overview

This integration uses import files and ODBC to connect to Vista.  The actual ODBC data flows are enabled through external requests that come from outside of the Trimble Viewpoint cloud. 

Deployment Methodology

We do not support hosting of this product in our cloud; this is a solution either hosted in the vendor's cloud infrastructure or in a customer's dedicated network.

The integration will be enabled by the use of a TLS Database Endpoint (TLS VPN) the third party or customer cloud.  In addition, a SQL Service Account will be necessary for the solution to authenticate to the Vista database and read and write master data (e.g. jobs, phase codes, etc.) when necessary.

tl;dr:  This solution uses BOTH ODBC and file import connectivity into Vista.  For ODBC, a TLS Database Endpoint (TLS VPN) is recommended.  The files that are exported from mJobTime contain time data for import into Vista using manual IM file imports.