Cheshire County Council Improves Reporting Performance by Using DBMoto

THE CHALLENGE

One of the Council’s Project Teams was developing its own reports from a Gupta SQLBase database, but found that in doing so, the database performance substantially reduced, often causing the main application to grind to a halt.  To avoid this issue, the process was stopped from running during the day.  This meant that the staff had to remember to start the reports running as they left the office for the evening.  Occasionally this led to issues with the overnight database backup running very slowly leading to system lockups in the morning.

John Hamstead, Programme Manager, Information Services Team, decided that the way around this problem would be to separate the reports from the other data and to run them independently.  To do this, the team had to find an effective way to replicate data.

THE APPROACH

THE SOLUTION - DBMoto Data Replication and Transformation

DBMoto provides data replication and transformation for an organisation’s enterprise server and desktop needs.  Business applications depend on data from multiple databases and DBMoto is the solution for enterprises that need to move data between database platforms and understands that fast data delivery between relational database platforms yields better performing applications.

DBMoto performs refresh and real-time data replication for enterprise server and desktop replication needs.  All major database platforms such as IBM DB2 UDB (including System i5/iSeries/AS400 and zOS), Oracle, Microsoft SQL Server, Sybase ASE, SQL Anywhere, Cloudscape, MySQL, Informix, Ingres, PostgreSQL, Microsoft Access, Gupta SQLBase, Firebird and Solid are supported.

Cheshire County Council deployed DBMoto to replicate data from the Gupta SQLBase database to a Microsoft SQL Server database.  In this environment the data is available to users to interact without the performance impact to the production system as previously experienced.  This has been of particular benefit to the project sponsors, the reporting team who can now deliver reports on request. 

THE RESULTS

John went on to say, “So what began as one project evolved into two and we now have two project teams using the same software.  Although the overall set-up costs and ease of use were more relevant deciding factors in this instance than the cost of the product, the price was still extremely competitive.  Ultimately, however, we found DBMoto was very simple to set up and simple to use”. 

DBMoto was successfully implemented without the need for external resources which made it possible for Cheshire County Council to build their solution within budget.

WHY DSCALLARDS?

WHY HIT SOFTWARE?

HiT Software is a leading software provider of secure middleware data access and data replication products.  Since 1994, HiT Software’s products have enabled customers from large, medium and small companies to integrate relational data in mission-critical applications across all industries.  Visit www.hitsw.com.