Databuild Purchase Order Integration - Installation
- Matthew Garrett
Return to Databuild Purchase Order Integration
Article Index
Any workstation or server that is to perform integration must first be installed with all the required software to access and operate the respective systems (including Framework).
Ensure Databuild is installed and working on the server/workstation. For detailed instructions for installing and configuring Databuild, please see the relevant Databuild installation product manuals.
Framework Integration
For detailed instructions on installing Framework Integration , refer to the Framework Integration Installation Guide.
In brief, the installation of the following is required:
Microsoft SQL Server 2005 / 2008
Insula Software Core Components
DSN configurations for:
Framework (FworkSQLEcm)
Framework Licence (FworkSQLLic)
Framework Databuild System (FworkDBBuildSys)
Framework Databuild Job (FworkDBBuildJob).
Licence Installation
The following licence is required to be installed and activated on the database server. This can only be done by Insula Software and will be completed as a part of purchasing Framework Integration .
Licence # | Description | Value |
|---|---|---|
203 | Databuild Purchase Orders | -1 |
Databuild Purchase Orders DSN Installation
For Framework Integration to read information from Databuild, an ODBC Data Source Name (DSN) connection to the Databuild Job database is required.
If using a database with a Microsoft Access database:
Open Data Sources (ODBC) (Start > Control Panel > Administrative Tools > Data Sources (ODBC)). The ODBC Data Source Administratordialog will be displayed.
Select the System DSN tab.
Click the Add button. The Create New Data Source dialog will be displayed.
Select Microsoft Access Driver (*.mdb)
Click the Finish button. The ODBC Microsoft Access Setup dialog will be displayed.
Enter the Data Source Name.
Enter a description.
Click the Select... button. The Select Database dialog will be displayed.
Browse to the *.mdb file.
Click the OK button. The Select Database dialog will close.
Click the OK button. The ODBC Microsoft Access Setup dialog will close.
Click the OK button. The ODBC Data Source Administrator dialog will close.
If using a database with a Microsoft SQL Server database:
Open Data Sources (ODBC) (Start > Control Panel > Administrative Tools > Data Sources (ODBC)). The ODBC Data Source Administratordialog will be displayed.
Select the System DSN tab.
Click the Add button. The Create New Data Source dialog will be displayed.
Select SQL Server.
Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
Enter the name.
Enter a description.
Select or enter a server name.
Click the Next button.
Click the Next button.
Tick: Change the default database to
From the Change the default database to drop-down list, select the database.
Click the Next button.
Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will close.
Click the Test Data Source... button. The SQL Server ODBC Data Source Test dialog will be displayed.
If successful, click the OK button. The SQL Server ODBC Data Source Test dialog will close.
Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
Click the OK button. The ODBC Data Source Administrator dialog will close.
Databuild System Database DSN Installation
For Framework Integration to read information from Databuild, an ODBC Data Source Name (DSN) connection to the Databuild System database is required.
If using a database with a Microsoft Access database:
Open Data Sources (ODBC) (Start > Control Panel > Administrative Tools > Data Sources (ODBC)). The ODBC Data Source Administrator dialog will be displayed.
Select the System DSN tab.
Click the Add button. The Create New Data Source dialog will be displayed.
Select Microsoft Access Driver (*.mdb)
Click the Finish button. The ODBC Microsoft Access Setup dialog will be displayed.
Enter the Data Source Name.
Enter a description.
Click the Select... button. The Select Database dialog will be displayed.
Browse to the *.mdb file.
Click the OK button. The Select Database dialog will close.
Click the OK button. The ODBC Microsoft Access Setup dialog will close.
Click the OK button. The ODBC Data Source Administrator dialog will close.
If using a database with a Microsoft SQL Server database:
Open Data Sources (ODBC) (Start > Control Panel > Administrative Tools > Data Sources (ODBC)). The ODBC Data Source Administrator dialog will be displayed.
Select the System DSN tab.
Click the Add button. The Create New Data Source dialog will be displayed.
Select SQL Server.
Click the Finish button. The Create a New Data Source to SQL Server dialog will be displayed.
Enter the name.
Enter a description.
Select or enter a server name.
Click the Next button.
Click the Next button.
Tick: Change the default database to
From the Change the default database to drop-down list, select the database.
Click the Next button.
Click the Finish button. The ODBC Microsoft SQL Server Setup dialog will close.
Click the Test Data Source... button. The SQL Server ODBC Data Source Test dialog will be displayed.
If successful, click the OK button. The SQL Server ODBC Data Source Test dialog will close.
Click the OK button. The ODBC Microsoft SQL Server Setup dialog will close.
Click the OK button. The ODBC Data Source Administrator dialog will close.