Case Study
Rotech Rural : Database Sync
To support growing data management and reporting requirements, Gauge Industrial & Environment partnered with DB Gurus to implement a customised database solution. The system improved information management, reduced manual effort, and delivered reliable insights through streamlined reporting and enhanced data visibility.
Client
Rotech Rural
Platform
Database Sync
Industry
Agriculture
Services
Custom Database, Enhancement Operational, Support, Reporting Solutions
Project Brief
Rotech are a rural company successfully creating better farm fencing solutions through practical, user centred innovation. Working alongside farmers and fencing contractors for 20 years they have created some great new solutions to old fencing problems.
The Solution Delivered
Phase 1 is redesigning their Access system to stop it crashing and make it accessible by remote users.
Phase 2 is to put the database online accessible via a browser.
The Results
DB Gurus delivered a tailored database solution that improved the management and accessibility of critical business information across Rotech Rural. By streamlining data processes and providing greater visibility of key operational data, the solution helped reduce manual effort and support more efficient day-to-day operations. The enhanced platform enabled users to access accurate information more easily, improving productivity and supporting informed business decisions.
REVIEW
What was the project timescale?
Rotech first contacted DB Gurus in June 2020. First major delivery October 2020.
What challenges have been faced along the way?
Speed has been the biggest issue – getting the database to update in a timely manner when the sync has been running. We also have issues with the old software and their local network which have had to be resolved.
What were the successful aspects of the project?
Implemented their syncing allowing staff to use their Access databases remotely with the data automatically syncing via the internet to the office database. Asynchronous.
What special or new features have been used?
First time using the sync queue with a client database – this is where all data changes are converted into JSON format and added to an online database which are then read and processed by the other Access system to keep them up to date. Data is added to and read from the queue using our standard TDB API that was developed for our cloud database platform.
Project Snapshot
Business Need
Improve the management, accessibility, and visibility of critical business information across the organisation.
Solution
Microsoft Access, Microsoft SQL Server, Custom Database Development, Databasee Sync
Technologies
Microsoft SQL Server, Custom Database Development, Reporting Solutions, Environmental Tracking System
Duration
October 2020
DB Gurus Services
Database Development, Database Optimisation, Reporting Solutions, Support & Maintenance
Ready to
Future Proof Your Business?
Book your FREE 30-minute consultation or get a ballpark estimate today. Discover how our technology solutions can streamline your workflows, boost performance, and future-proof your business.
Trusted by leaders in mining, manufacturing, and government. ISO 9001 & ISO 27001 certified. Local team. Real results.