ExSync
Data
Synchronisation
ExSync is a multi-threaded application that connects to the Pervasive SQL server via ODBC and synchronises the Advanced Exchequer data to the MS SQL Server or Oracle MySQL. ExSync for Advanced Exchequer is fast, reliable and affordable.
ExSync Data Conversion & Synchronisation For Advanced Exchequer
ExSync is a multi-threaded application that connects to the Pervasive SQL server via ODBC and synchronises the Advanced Exchequer data to MS SQL Server or Oracle MySQL.
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 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 Advanced Exchequer customers using Advanced 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 Advanced 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.
As ExSync is highly customisable for your data synchronisation needs, we are able to work with almost all versions of Pervasive database and Advanced Exchequer. This additionally simplifies the data migration process for customers who are looking to quickly migrate from Advanced Exchequer cost-effectively.
A selection of ExSync’s features:
- Corrections Table for Transactions/Lines: this allows adjustment values to be added to the transactions, correcting posting run failure values for easy reporting where Advanced Exchequer is out of balance
- Optional Service Application: run selected data synchronisation in conjunction with the Windows Scheduler
- Remote Trigger: the service can be activated from across the network via command line or batch file from other applications
- SQL Code Execution: SQL code can be added to implement Transactions and Jobs synchronisation to modify data or execute corrections
- Last Used Date for Quicker Updates: select Customers, Suppliers and Stock data from the last used date to speed up updates with options to select all data, from a particular date, or from today
- Job Selection: jobs can be chosen from a range of job numbers, all jobs, or from a job number onwards to speed up the update process
- Null Value Conversion: as Advanced Exchequer leaves null values in the company/daily rate currency values, we set all null values to 1 so that “divide by zero” errors on multi-currency reporting are rectified so that division is possible.
Interested in seeing if ExSync is the right solution for you? Contact us for more information.
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 Advanced 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 Advanced Exchequer.
The synchronisation time dropped 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. 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.
The ExSync Windows Service Application had been beta-tested at Edinburgh Telford College where Exchequer Dynamics was contracted to deliver an integration with IBM’s Cognos Business Intelligence platform.
EDL was 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.