ExSync
Data
Synchronisation

ExSync is a multi-threaded application that connects to the Pervasive SQL server via ODBC and synchronises the Exchequer data to the MS SQL Server or Oracle MySQL. ExSync for Exchequer is fast, reliable & affordable.

Exchequer Dynamics ExSync
exchequer dynamics exsync

ExSync Data Conversion & Synchronisation For Exchequer

ExSync is a multi-threaded application that connects to the Pervasive SQL server via ODBC and synchronises the Exchequer data to MS SQL Server or Oracle MySQL.
In the process, it converts all of the 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 synchronise multiple data streams of data.

“ExSync has allowed us to get control of our balance sheet discrepancies and maintain proper stock control” (Kelly Bruce. Puls UK Limited).

The software does not have any dependencies other than the requirement of a Pervasive ODBC client and an MS SQL Server to write data to.

One of the problems facing Exchequer customers using Exchequer CRM and other tools is that the data synchronisation takes all night. With ExSync, millions of records an hour can be processed and the data can be used in any other CRM system.

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. Using simple stored procedures, the data extracted can be posted in any or many other systems.

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. Now available with extended memory usage on 64bit Windows and automated archiving of transactions. Enhanced performance doubling the batch processing speeds.

ExSync 4

It has been a very busy year for us at Exchequer Dynamics. All sorts of varied projects have arisen where we have had to think on our feet and adapt quickly to customer requests for much more than raw data extraction from Exchequer.

To name a few we have had eCommerce integrations with Ocean eCommerce & Magento leading to a developing framework that can fit any database-driven eCommerce engine. Web developers can now get a site live in days instead of weeks or months.

We have an ongoing project with Edinburgh Telford College to integrate Exchequer with IBM Cognos BI. Working closely with Cognos experts at Barrachd we have developed the ultimate business intelligence platform for Exchequer. This led to the development of a windows service application for our ExSync engine.

Once development started on the Windows Service Application, a decision was made to completely re-write the whole framework of the ExSync product to take into account the rapid release program. With the new version, we can now bolt in new releases of the Pervasive database quickly and at the same time, allowing users to select the Exchequer version going back to version 6.00 from the current version 6.10. Previously we had a version for each Exchequer release.

This simplifies the data migration for customers wanting to move away from Exchequer and we can act quickly and cost-effectively to migrate data. Another by-product of the development of the new Windows Service version was a blistering performance gain.

We now find ourselves advising Exchequer customers looking to migrate from Exchequer and with our ExFusion product we are able to help them make the decision to stay and extend Exchequer with our cohesive integration layer.

It was not on the road map, but customer requirements have caused us to take a slight detour and develop the completely new ExSync version 4 with the option to be run as a service. Offering a new interface and major new features:-

A Corrections table for Transactions/Lines has been added. This allows adjustment values to be added to the transactions to correct posting run failure values where Exchequer is out of balance. This is a major step forward and makes reporting easy.

An optional service application to run selected synchronisation in conjunction with the Windows scheduler.
The service can also be triggered across the network from the command line or batch file from other applications.
The ability to add SQL code execution to Transactions & Jobs synchronisation to modify the data or execute corrections.
The ability to select Customers/Suppliers/Stock from the last used date. This will speed up updates with options to select all data, from a particular date or from today.
The ability to select Jobs from a range of job numbers, all jobs, or from a job number forward. This speeds up the update process.

Exchequer leaves null values in the company/daily rate currency values which causes “divide by zero” errors on multi-currency reporting. We set all null values to 1 so that division works.
At the back end, we have made provision for a ‘Developer’ edition which will be a further upgrade option. This gives customers and/or their developers the ability to have post-synchronisation custom stored procedures, the triggering of Shell API’s or external events/applications/batch files. Also, on the development road map, there will be SOAP integration, turning ExSync into an automation framework. The Service and Developer edition allows for complete customisation.

Developers can add code to do pretty much anything on the extracted data. The possibilities are endless. It transforms the engine into a management system capable of executing multiple procedures on any system. It is limited only by the constraints of MSSQL, MySQL or your imagination.

In August 2012, the service edition ver. 1.0.0.1 will have the ability to trigger global events, which is something not possible in the standard application. When the service finishes a sync cycle it will be able to trigger a global procedure that can trigger many other procedures or VB script…. Shell…. You name it! The scope is absolutely huge! All running from Windows schedule or on-demand.

ExSync: Service

Having listened to our current and potential customers, Exchequer Dynamics has taken the current data conversion application ExSync to the next level as a Windows service.

A service is designed to be a 24/7, background process to perform specific functions and generally does not require user intervention. As far as ExSync is concerned it has been designed to be ‘set and forget’.

As part of the companies ‘Quality without Compromise’ ethos, the development team have been looking further at memory management, data throughput and enhancing overall performance.

The result of the hard work is impressive and rewarding:

The ExSync Windows Service Application has a staggering 78% increase in performance and 30% drop in memory usage over the existing ExSync product (v.3.0.1.1) which is already renowned as the fastest tool on the market for data extraction from the Exchequer accounting system. This represents a worthwhile upgrade for customers with larger data sets.

We have bench-tested both products using an average sized companies data for a three-year period, extracting 1,538,019 records from Exchequer.

The graph below shows the synchronisation time dropping from nearly 2½ hours to just 30 minutes!

We also tested the memory usage for the service. We tested using 4GB of RAM (Memory allocation for the service), which is the recommended amount of memory to achieve the best results. (For more information on the specifications of the bench-test PC, please see the end of this news post.) You can see from the graph the memory usage has decreased by 30% when using the Windows Service Application!

The records processed per second is equally as staggering with the new ‘Service’ crunching through nearly 850 records per second.

For full report data – please read out ExSync: Service comparison document:

The new ExSync Windows Service Application is currently being beta-tested at Edinburgh Telford College where Exchequer Dynamics is contracted to deliver integration with IBM’s Cognos Business Intelligence platform.

EDL is working in partnership with award-winning IBM Cognos partner Barrachd to deliver the multi-dimensional OLAP cube technology to the college’s finance department. The power of this technology and the speed with which organizations can analyze large amounts of data has to be seen to be believed. OLAP cubes are a critical business intelligence tool for the competitive and forward-thinking enterprise.

The ExSync Windows Service will be due for general release at the end of Q2. For our existing customers currently using the standard ExSync application, there will be an upgrade path to the new ‘Service’.