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.