Skip to content

Central DB Config. Utility

This is a utility provided by Codis to allow user quickly move between companies in Excelerator.

The utility is not included in any of the standard excelerator installations. (This is intentional - it is assumed that it would not be deployed to end-users as a matter of routine.) It can be download from our website as a single installer file, CentralDBConfigSetup.zip.

Once installed, an option "Launch Central DB Config" should appear on the "Codis Excelerator" menu, in the Windows menu (not the Excel menu).

iecentraldatabaseconfig2.gif

On running this option, the program will ask user to enter the connection details to the Master Database.

(The installation routine will insert a table (if it is not already inserted) ExcelCompanies table into this database, not necessarily csmaster.)

  1. A maintenance screen will then be displayed.
  2. Enter a record for every Sage company user wish to use Excelerator with.
  3. The data entered is the same data, user would enter if you were entering the connection details in Excelerator, except that the UserName and Password can be left blank.

In this case, the Master Database connection user name and password entered in Excelerator will be used when connecting to the Sage databases entered in ExcelCompanies.

The 'Test Connection' button will allow user to test any entered connection details. User advised to keep a back up copy of the data entered.