/
Databuild Purchase Order Integration - Framework Preparation

Databuild Purchase Order Integration - Framework Preparation

Owned by Julie Doyle-Whitelock (Deactivated)
Aug 08, 2017

With the implementation of any new type of integration there are several issues to consider in preparing Framework for the change.

Framework Data Updates

No existing data must be modified to support the use of Databuild Purchase Orders integration.

The only consideration in this type of integration is the jobs included in the integration process.

  • Jobs where the External System Link BOQ Reference field is not N/A (this can be viewed on the Job Overview screen).
  • Additional specific criteria as defined in the Integration Process section of this help guide.

Should any mass data updates be required to prepare jobs for integration, please contact Insula Software for assistance.

Framework Security

As a part of implementing Framework Construction Logistics Desktop, Framework security should be reviewed to ensure only relevant users have access to this new software.

Framework Preferences

In the Framework ECM Security module, the following preference settings require modification.

Estimation System

Preference Group: Framework Construction Logistics (Tablet) > Integration

Preference: -11001 - Estimation System

Preference Level: Default

Value: Databuild

Databuild ODBC DSN System Database Name

Preference Group: Framework Construction Logistics (Tablet) > Integration > Databuild Settings

Preference: -1002 - System Database - ODBC DSN Name

Preference Level: Default

Value: [Databuild System DSN Name] (e.g., FworkDBuildSys - known after installation)

Databuild ODBC DSN System Database Connect String

Preference Group: Framework Construction Logistics (Tablet) > Integration > Databuild Settings

Preference: -1003 - System Database - ODBC DSN Connect String

Preference Level: Default

Value: "uid=xxx;pwd=xxxx" if needed.

Databuild ODBC DSN Job Database Name 

Preference Group: Framework Construction Logistics (Tablet) > Integration > Databuild Settings

Preference: -1004 - Job Database - ODBC DSN Name

Preference Level: Default

Value: [Databuild Job DSN Name] (e.g., FworkDBuildJob - known after installation)

Databuild ODBC DSN Job Database Connect String 

Preference Group: Framework Construction Logistics (Tablet) > Integration > Databuild Settings

Preference: -1005 - Job Database - ODBC DSN Connect String

Preference Level: Default

Value: "uid=xxx;pwd=xxxx" if needed.