Before using an external program in a 'live' system, thoroughly test all aspects of the program using a test system that accurately reflects the real system (including database size and data retrieval frequency).

You should perform further tests once the program is installed on the live system to verify that the program operates correctly. It is important that arrangements for such checks are made and that sufficient time is allowed to perform complete and satisfactory testing.

Caution should be taken with the automation methods that can update or modify the database as this may affect the operation of the system.

Poorly written external programs using the automation interface could cause poor system performance.

Usernames and Passwords should not be hard coded into any external programs. You should ensure that the users either logon each time the program is run or that security information is stored securely in a manner that can allow it to be updated on a regular basis.