Configuring Multi Companies

Central DB Config Utility

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

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

CentralDatabaseConfig - Excelerator Help

On running this option, the program will ask you 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.)

A maintenance screen will then be displayed. Enter a record for every Sage company you wish to use Excelerator with. The data entered is the same data you 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 you to test any entered connection details. You are advised to keep a back up copy of the data you enter.

ExcelCompanies Table

This can be set up on any database, but when choosing which database to set up on consider:
•It is easier to use the same database user to access this table as used to access Sage tables
•If you place it in a Sage company database, remember to back up it's contents in case it is erased during an upgrade.

The fields on the table relate to the entries in the connection box (see Central DB Config Utility).

Below is a schema for creating the table in SQL Server. Data can be entered into this table using the Central DB Config Utility, using SQL, or in SQL Enterprise manager for SQL Server.Excel Companies Table

ExcelCompanies Table Schema

 

CREATE TABLE [dbo].[ExcelCompanies] (
[Company] [char] (10) NOT NULL ,
[Description] [char] (30) NULL ,
[Server] [char] (20) NULL,
[DBName] [char] (20) NOT NULL,
[UserName] [char] (20) NULL,
[Password] [char] (20) NULL,
[NLDatabase] [char] (20) NULL,
[PLDatabase] [char] (20) NULL,
[PODataBase] [char] (20) NULL,
[STDataBase] [char] (20) NULL,
[PRDataBase] [char] (20) NULL,
[CEDataBase] [char] (20) NULL,
[SLDataBase] [char] (20) NULL
GO
) ON [PRIMARY] CREATE UNIQUE CLUSTERED INDEX [i_Company] ON [dbo].[ExcelCompanies ([Company]) ON [PRIMARY]
GO