Skip to content

Central DB Config Utility

This is a utility provided by Codis to allow maintenance of the ExcelCompanies table.

This utility is provided on an as-is basis.

  • 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 ftp site as a single installer file, CentralDBConfigSetup.exe.

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

  1. On running this option, the program will ask user to enter the connection details to the Master Database.
  2. (This is where the ExcelCompanies table is held, not necessarily csmaster.)
  3. It will then check if the ExcelCompanies table exists in the database. If it doesn't, it will offer to create the table.

A maintenance screen will then be displayed. Enter a record for every Sage company user wish to use Excelerator.

The data entered is the same data user would enter if user entering the connection details in Excelerator, except that the User Name 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 is advised to keep a back up copy of the data entered.