Back to Top

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.

Service Icon - ExSync: Service Application

Refresh Icon - For those new to ExSync, Please view our product page

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 on-going 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:-

  1. 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.
  2. 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.
  3. The ability to add SQL code execution to Transactions & Jobs synchronisation to modify the data or execute corrections.
  4. 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.
  5. 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.
  6. 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.
  7. 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 allow 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.
  8. In August 2012, the service edition ver. 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.

SoftwareThe following table shows the differences between releases: