External Tables

Database Installation - External Tables

You can configure Impact to use an external Customer table instead of the built-in one. You may wish to do this if you already have an application (say a Management Information System (MIS)) with its own custom database, and you do not wish to duplicate the data. 

Normally, this option would be used on the initial configuration of an Impact database. It would be difficult to configure an external Customer table once customer information has already been created in the Impact Customer table.  Please contact Arden support should you wish to undertake a conversion of existing data.


Please note. The External Customer Database Tables feature is NOT compatible with the use of Impact Enterprise Services or WEBcnx products.


Use external Customer database table

Switch this option on to use this feature.


Note. There are certain requirements to be met for any external Customer database table: It must have a unique integer index, a unique string name, and you must have ODBC drivers for the database.

Connection

Choose the ODBC source name

Table

Enter the Table name (equivalent to CUSTOMER),

Select SQL

Enter some code to allow customers who are not active to be excluded.

Key field

Enter the Key Field name (a unique integer, equivalent to CS_KEY).

Code Field

Optionally enter a Code field name (a unique string, equivalent to CS_CODE).

Name Field

Enter the Name field (again, a unique string, equivalent to CS_NAME). 

Active Field

Optionally enter an Active field name (such as CS_ACTIVE) where the customer can be defined as either active or inactive.

Test

Use this button to check the entered database information, showing the customer names in the drop-down list.

Use palette database for storing manufacturing palettes

Switch this option if required.

Cache database palettes on workstation

Switch this option on to improve performance when accessing the palette database.

Did you find it helpful? Yes No

Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.

You may like to read -