ExSync is a multi-threaded application that connects to the Pervasive SQL server via ODBC and synchronizes the data to Microsoft SQL Server or Oracle MySQL. (version dependant)
In the process it converts all of the Advanced Exchequer field values that are stored as split integers and also the dates stored as text converted to date time values.
Because it is multi-threaded it can connect to many tables at once and synchronize multiple data streams of data.
A number of useful features have been built in to allow visual query building, export to Excel and PDF reporting. As a result complex queries can be constructed and the data output in a fraction of the time it takes Exchequer to process.
The software is does not have any dependencies other than the requirement of a Pervasive ODBC client (licence required from Exchequer for ODBC connections) and either MS SQL Server or Oracle MySQL to write data to.
The number of Exchequer companies is unlimited and the MS SQL/MySQL server schema can either be an independent database or can form part of an existing database so that queries can be built across applications. Indeed, the MS SQL/MySQL configuration within ExSync allows for multiple SQL databases. We have designed this application with power, flexibility and ease of use in mind
The whole ethos of the development has been to produce a suite of tools that allow for rapid reporting and analysis of the data.
Exchequer Dynamics Limited
Units 20-21 Somerford Business Park
Christchurch
Dorset
BH23 3RU
United Kingdom
Sales Tel 0845 5194 487
Technical 01933 429 800