Optional Add-on for sheriff sql
Developed by Pro Systems and Pro Software, SQL Cloud Service is an optional add-on package for Sheriff SQL. It extends parts of your local database into the cloud. It then presents to your debtors and deputies the functionality to access the cases on their accounts.
|A desktop application called Sheriff Website Manager.|
|Storage on our secure private cloud servers for your database.|
|A customizable secure and responsive website.|
|A browser based application called Data Service.|
|A browser based application called Deputy Service.|
We promised we'd take you into the future.
Cloud computing without downtime !!
Sheriff Website Manager
Appropriately called Sheriff Website Manager, this app runs minimized on the taskbar when Sheriff SQL starts up. Obviously, it requires a live Internet connection. It is primarily responsible to keep cloud data synced with local data. This magic happens using background worker threads to do the heavy processing, a technology developed for Microsoft .Net™ applications. It does this at all times. It can't be shut down whilst Sheriff SQL is running. Neither can it be stopped. Sheriff SQL operators continue working exactly as always. There is nothing special they must do and nothing different they will see. Whatever they change locally also changes remotely. They don't lift a finger to make it happen. Should the Internet connection break NOTHING is lost. Changes are queued and will happen when the connection becomes live again.
Cloud database sync's withoutApart from it's primary task of syncing the databases, Sheriff Website Manager has the following six user functions:
user intervention !
Click the links below to see more detail on each function.
Your database will live on one of our secure virtual private servers. We control the server and everything on it. There is no limit to the size of your database. We do not restrict the number of connections or the amount of bandwidth used by connections. Everything is included.
Because we are website resellers (meaning we supply and host websites) we create a website for you, ensure that it's URL is unique, register it on the www (world wide web), and configure it. The website is not for bells and whistles! It's absolutely required, reason being it hosts a browser based application used by your debtors called Data Service. But that's just for use by your debtors. A website also needs a public interface that:
Click HERE to see the website of Sheriff White River, which demonstrates how the website appears. This is a real live site with a proper SSL certificate.
This is a browser based application used by your debtors to access the cases on their account. It exists on the website. What a debtor can see and access depends on the permission status you set for that account. Debtors have nothing to install. They can use any Internet enabled device that has a browser. The application is cross platform compatible so even iPhones, Mac computers and other Unix based OS's can use it. They access the app using a hyperlink that they get when receiving email from you. The hyperlink is unique and secure for each debtor and allows Data Service to identify them. They then have to login to their accounts using a password that they themselves create. Data Service allows the debtor to:
Below are some screenshots of Data Service running in a browser.
More information about Data Service ...
Apart from access permissions discussed in Debtor Management above, debtors need query credits to in order to see the content of their returns when they do a case detail query. One case detail query = one query credit. All other types of queries are free. When a debtor logs in to their account for the first time they get 50 free query credits once off. This means they can see a case detail page 50 times for free. Thereafter they need to purchase query credits @ R0.50 per query credit. This is not to make money out of them. It is to cover your cost of the Sheriff Website Manager software, the website, and the bandwidth used.
This is also a browser based application and it's used by your deputies to access their non return cases. They will most probably use it on their mobile phones or a tablet. It costs them nothing. We are sure they will find the functions very easy to use. The 'Manage' function allows them to provide feedback to debtors and office staff. The 'Bookin' function allows them to bookin their cases and print a Bookin Report. This they use when they hand their served cases back to the office to avoid problems with 'lost' documents etc.
Below are some screenshots of Deputy Service running on a mobile phone.
We do require a minimum infrastructure. This is to avoid problems on your side as well as ours. Only Sheriff's having the following minimum infrastructure will qualify to use this package: