Central Database Definitions

It is possible to set up a central definition of the Sage databases to be used by Excelerator. This can save the end-user having to enter all the connection details when changing companies.

The central definition is held in a new table - the ExcelCompanies table. The connection set up for each Excelerator user then points at this table, and the user selects which company to use from a simple list showing a company name and description.

To set this up you will need access to the Sage database with permissions to create a table and grant rights on that table Codis provide a utility, CentralDBConfig, which will create the table and allow records to be entered. It also provides a back up and restore facility.