“The Data warehouse has been a valuable add-on. It has allowed us to produce the reports we wanted based on data, which would have been difficult to process in Exchequer Enterprise. It’s fast, easy and you don’t have to be an Enterprise Expert!. We have also used the Data warehouse Enterprise Information within our own call logging system written in MS Access” says Barry Moorcroft of Central Data Installations.

Tell me again!

Show me a demonstration video

Download Manual/Specification

Download Microsoft SQL Database Install Manual

Prices

Downloads

Update History

The Data Warehouse extracts Exchequer data and replicates it in an external Microsoft Access Database or Microsoft SQL Database.

Uses/Benefits:

Fully Microsoft compatible

Can use virtually any report engine with Microsoft Access or Microsoft SQL. These database engines can deliver extremely fast reporting as they can be optimised for delivering complex reports whereas Enterprise is optimised for processing transactions at speed.

Easily use the information to integrate within other systems

The data warehouse can be used for integration with bespoke systems. Changes to the structure of the database will not affect Exchequer Enterprise, extra field indexes can be added to the table for bespoke uses.

Extra derived fields such as:-

·       First bought, Last bought, Last sold dates on Customer, Stock and Stock location record (based on invoice).

·       Customer records contain the last 26 period turnover figures.

·       Exchequer Notes are posted to memo fields.

·       Addresses and stock description are also posted to memo fields.

·       Job record contains YTD figures for the 10 categories.

·       JobAnalysisTotals gives YTD figure for each Job analysis code.

The update program can be run over night to update an Access 97 Database or MS SQL Client/Server database.

Downloads

Install Software

To install

1) Create a directory called "Datawharehouse" and unzip the contains of file below in to this directory

2) Following the instructions in the Manual

10/3/2005 V2.1.10 Full Data warehouse program for Microsoft ACCESS (9Mb zip file)

10/3/2005 V5.6.0 Full Data warehouse program for Microsoft SQL (11Mb zip file)

Upgrade Software

Open the above ZIP file and extract "WareHouse.exe" to the data warehouse directory.

Example Data

22/12/2002 Electrics'R'Us example MS Access data file (2Mb zip file)

Please download the above Manual/Specification for more information and the Electrics'R'Us data files.

About Exchequer Enterprise

More Information about Exchequer Software

[ Home ] [ Up ] [ Prices ] [ Update History ] [ More about Exchequer Software ] [ IRIS Enterprise Software ] [ WebRangle Linking ]

Last modified: August 18, 2006