Databuild Client and Job Integration - Profile Configuration

IntegrationType

Description: 

Specifies the type of integration to be performed. This is a fixed value that should not be changed.

Setting: 

Databuild Accounts

ODBCConnectionType

Description: 

Indicates if the Databuild database is SQL Server or Microsoft Access.

Setting: 

1: SQL Server

2: Microsoft Access

ODBCDSN_Framework

Description:

ODBC DSN name for the Framework database.

Setting: 

FworkSQLEcm

ODBCConnect_Framework

Description:

ODBC DSN connection string for the Framework database.

Setting: 

None

ODBCDSN_FrameworkLicense

Description:

ODBC DSN name for the Framework Licence database.

Setting:

FworkSQLLic

ODBCDSN_IntMapping

Description:

ODBC DSN name for the Framework Integration Mapping database.

Setting: 

FworkSQLIntMap

ODBCConnect_IntMapping

Description:

ODBC DSN connection string for the Framework Integration Mapping database.

Setting: 

None

ODBCDSN_DataBuildSys

Description:

ODBC DSN name for the Databuild system database.

Setting:

FworkDBuildSys

DatabaseName_DataBuildSys

Description:

Databuild system database name.

Setting:

DataBuildSys

ODBCConnect_DataBuildSys

Description:

ODBC DSN connection string for the Databuild System database.

Setting:

"uid=enterUserName;pwd=enterPassword"

ODBCDSN_DataBuildJob

Description:

ODBC DSN name of the Databuild Job database.

Setting:

FworkDBuildJob

DatabaseName_DataBuildJob

Description:

Databuild Job database name.

Setting:

DataBuildJob

ODBCConnect_DataBuildJob

Description:

ODBC DSN connection string for the Databuild Job database.

Setting:

"uid=enterUserName;pwd=enterPassword"

Mail_System

Description:

Email delivery method.

Setting: 

0: no email will be sent.

1: email will be sent using MAPI.

2 (default): email will be sent using SMTP.

Mapi_Profile

Description:

Microsoft Outlook user profile name.

Setting:

(default): Outlook

Mail_From

Description:

The name or email address of who/where the email is being sent from.

Setting:

FrameworkIntegration

Mail_Recipient

Description:

These are the mail recipients of integration logs. Multiple addresses can be added if separated with a semi-colon (;). Spaces are not necessary before or after the semi-colon.

Setting:

enterRecipientEmail@yourDomain.com.au;integrationsupport@insulagroup.com.au

Mail_Subject

Description:

Email subject heading.

Setting:

"Framework Integration : Databuild Accounts"

SMTP_Server

Description:

If using Mail_System 2 (SMTP), add the SMTP Server name.

Setting:

enterSMTPServerName (replace this text with your SMTP Server name)

SMTP_UseSecurity

Description:

Is security used for the STMP server?

Setting:

0 (default): A username or password is not required.

1: A username and password is required. If this setting is used, the SMTP_UserName and SMTP_Pwd fields must have a valid username and password.

SMTP_UserName

Description:

A valid username for the SMTP server.

Setting:

enterUserName (replace this text with a valid SMTP Server User Name)

SMTP_PWD

Description:

A valid password for the SMTP username.

Setting:

enterPassword (replace this text with a valid SMTP Server Password)

CriteriaMethod

Description:

Job selection criteria for retrieving records from Framework to process.

Setting:

1: Single region/division.

2: Single job.

3: Single team.

4 (default): All jobs.

5: Accounts entity.

CriteriaData

Description:

Input criteria data for the criteria method.

Setting:

insert number; for example, if using CriteriaMethod 2, the setting for CriteriaData will be the specific job number to integrate on.

dBuild_ContactGroupCode

Description:

Code for the Databuild Contact group.

Setting:

2 (default): Databuild value that indicates the Contact group.

dBuild_GstRate

Description:

GST percentage rate.

Setting:

10 (default)

dBuild_CostCentreGroupCode

Description:

Code for the Databuild Cost Centre group.

Setting:

1 (default): Databuild value that indicates the Cost Centre group.

SaveClientLink

Description:

Determines if we add a reference to the Databuild customer in Framework's client record.

Setting:

0: Do not link the client. Each subsequent job will have a new customer record in Databuild.

1: Link the client Framework to the matching Databuild customer.

DBccBanks(-1)

Description:

n/a

Setting:

"N/A"

DBstatus(-1)

Description:

n/a

Setting:

"N/A"