| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
Return to Databuild Land Integration
Article Index
| Table of Contents |
|---|
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 including Framework ECM).
| Warning |
|---|
Ensure Databuild is Ensure Databuild is installed and working on the server/workstation. For detailed instructions for installing and configuring Databuildconfiguring Databuild, please see the relevant Databuild installation relevant Databuild installation product manuals. |
Framework Integration
For detailed instructions on installing Framework installing Framework Integration, refer to the Framework Integration Installation 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
...
Integration (FworkSQLIntMap)
Framework Databuild Job (FworkDBBuildJob)
Framework Databuild System (FworkDBBuildSys)
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 by Insula Software and will be completed as a part of purchasing Framework Integration purchasing Framework Integration .
Licence # | Description | Value |
|---|---|---|
247 | Databuild Land | -1 |
Databuild
...
Land Job DSN Installation
For Framework Integration to For Framework Integration to read information from Databuild, an ODBC Data Source Name (DSN) connection to the Databuild Land database the Databuild Land 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.