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 user 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.