Databuild Purchase Order Integration - Framework Preparation
- Matthew Garrett
Return to Databuild Purchase Order Integration
Article Index
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.