Feature |
Description |
| Connectivity |
Clearly one of Event 1 Software's signature traits is the ease that Event 1
products connect to Sage Timberline Office or SQL databases. Integrator makes use of proven
techniques and components to make the connection to your Sage Timberline Office or Prolog
Manager database easy. The connection to your Sage Timberline Office database is made via
Sage Timberline Office's ODBC driver but there is no need on your part to perform any
special configuration. Event 1's ODBC connectivity takes care of it for you! On
the Prolog Manager end, Integrator makes use of the MPS Application Integration
SDK (Software Developer Kit). The SDK allows Integrator to access your Prolog
Manager database while enforcing business and database rules.
|
| Wizard Driven |
When there is a task to accomplish that may involve multiple steps, Event 1's
approach is to present the tasks to you in a clear and easy to understand
wizard.
|
| Interfaces |
Event 1 worked with users of Sage Timberline Office and Prolog Manager as well as
industry consultants to determine the types of data that should be exchanged.
Based on this input, Integrator includes a very valuable set of interfaces:
|
Sage Timberline Office |
Direction |
Prolog Manager |
| AP Vendors |
User-Defined
(one way or bi-directional)
| Companies |
| JC Extras, Cost Codes, Categories |
One-way, Sage Timberline Office to Prolog |
Budget Codes |
| JC Original Estimates |
One-way, Sage Timberline Office to Prolog |
Original Budgets |
| JC Commitments |
One-way, Prolog to Sage Timberline Office |
Contracts (not prime contracts) |
| JC Commitment COs |
One-way, Prolog to Sage Timberline Office |
Subcontract COs |
| JC Cost Entries |
One-way, Sage Timberline Office to Prolog |
General Invoices
Contract Invoices |
|
| Easy Workflow |
The workflow process for integration consists of three steps. These three steps
may also be combined into a single operation if desired.
| Step |
Description |
(1)
Determine Modifications |
This step examines each database, translates the data into a structure
similar to the other database, compares it to the other database and determines
what is new and what has been changed. The result is a list of pending
modifications for each database. |
(2)
Approve Modifications |
This step allows the user to review in detail a list of the pending
modifications. Individual modifications can be approved, postponed for another
time or discarded (never to be performed). |
(3)
Perform Modifications |
The last step creates the new information in each database or modifies existing
information as needed.
|
|
| 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 Timberline Office 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 Timberline Office/Prolog values that
can be used to translate dissimilar values. Substitution tables can be created
for:
-
Company & Vendor IDs
-
Project & Job Numbers
-
Budget Codes & Cost Codes/Categories
|
| Unattended Operation |
Integration tasks can be executed via a command-line, batch file or scheduled
task using the IRUN application (included).
|
