IntegratorExchange project data between Prolog Manager and Sage 300 Construction and Real Estate
Two powerful industry standards brought together: Prolog Manager and Sage 300 Construction and Real Estate. Event 1 Software’s Integrator is the Trimble Project Systems authorized integration solution for Sage 300 Construction and Real Estate. Integrator was developed by Event 1 Software, Inc., an authorized Sage Development Partner in partnership with select Trimble Project Systems customers. This is an application designed and built to meet your financial data integration needs. Integrator eliminates dual entry and worry by seamlessly integrating your Sage 300 Construction and Real Estate financial information with Prolog Manager’s robust cost control module. This tool saves you time and enables complete cost-to-date reporting!
With Integrator you can exchange the following types of data in the direction shown:
|Sage 300 Construction and Real Estate||Direction||Trimble Prolog Manager|
|Extras, Cost Codes, Categories||Budget Codes, Budge Group Lookup Lists|
|Approved Estimate Changes||Budget Changes|
|Commitments (Purchase Orders)||Purchase Orders|
|Commitment COs||Subcontract COs|
|Costs Actual or Billed||General & Contract Invoices|
|AP Invoices||General & Contract Invoices|
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.
|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.
Other user-defined mappings include company/vendor types, address types, contacts, contract/commitment types, contract/commitment dates and subcontract CO/commitment CO dates.
|Flexible Settings||The user-defined settings for each interface give you control over how data will be exchanged and when.|
|Substitution Tables||Substitution Tables allow you to define sets of Sage 300 Construction and Real Estate & Prolog values that can be used to translate dissimilar values. Substitution tables can be created for:
|Unattended Operation||Integration tasks can be executed via a command-line, batch file or scheduled task using the Integrator Tasks application (included).|
Click here for information about supported operating systems, versions of Excel, versions of Sage 300 Construction and Real Estate, and versions of Prolog Manager.