Integrated Data

With Integrator you can exchange the following types of data in the direction shown:

Sage 300 Construction and Real Estate

Direction

Trimble Prolog Manager

Vendors

Companies

Extras, Cost Codes, Categories

Budget Codes, Budge Group Lookup Lists

Estimates

Budgets

Approved Estimate Changes

Budget Changes

Commitments
(Purchase Orders)

Purchase Orders

Commitments
(Subcontracts)

Contracts

Commitment COs

Subcontract COs

Costs
Actual or Billed

General & Contract Invoices

AP Invoices

General & Contract Invoices

Licensing

Integrator is licensed according to the specific types of data that you wish to exchange. In this way, you have a wide variety of options available but you only pay for the options that you plan to use. Each arrow in the list above represents a licensed feature.

Features

Feature

Description

Connectivity

Clearly one of Event 1 Software’s signature traits is the ease with which products connect to Sage 300 Construction and Real Estate or SQL databases. Integrator makes use of proven techniques and components to make the connection to your Sage 300 Construction and Real Estate or Prolog Manager database easy. The connection to your Sage 300 Construction and Real Estate database is made via the ODBC driver for Sage 300 Construction and Real Estate and there is no need on your part to perform any special configuration. Event 1 Software’s ODBC connectivity takes care of it for you! On the Prolog Manager end, Integrator makes use of the Trimble Application Integration SDK (Software Developer Kit). The SDK allows Integrator to access your Prolog Manager database while the SDK enforcing business and database rules.

Wizard Driven

When there is a setup or workflow task to accomplish that may involve multiple steps, an Integrator wizard guides you through the necessary steps.

Easy Workflow

The workflow process for integration consists of three steps. These three steps may also be combined into a single operation if desired.

Reports

After the “Determine Modifications” and “Perform Modifications” steps of the workflow process, Integrator produces a recap of the task. This provides a list of the data that was added or changed as well as any related warning messages or rejections. All reports are produced in an easy-to-navigate HTML format that can be saved, retrieved, and printed.

Flexible Mappings

Sage 300 Construction and Real Estate Job Cost and Prolog Manager each provide a different set of options for defining the work breakdown structure (WBS) of a job. Integrator overcomes this by providing a “WBS Relationship Wizard” that guides you through the setup of a mapping between the two structures.