Central Database Definitions

Overview

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.