When it comes to sync, Adesso is second to none
Add Offline Sync to Your EXISTING Microsoft SQL Server Database
Since Adesso uses Microsoft SQL Server as its datastore, it plays nice with existing SQL server database applications. This means that adding sync and offline capability to your existing SQL Server database application is simple and easy with Adesso, without the need to rebuild your schema.
Build Enterprise-Grade Apps With Complex Workflows
- Four Types of Sync Per User, Per Table
- Four Types of Conflict Resolution Per User, Per Table
- SQL Statement Filters in Either or Both Sync Directions
- Advanced Controls from a Single Admin Portal
- Audit Trials When You Need Them
- Two Types of Credentialing
The Adesso Server is the “brains” of the Adesso platform. It handles all requests made by Adesso Client, Adesso Web Client, and web service calls via the Adesso WebServices APIs. Through its unique SyncAmin web portal, admin users can control user or user group permissions down to the individual column level, sync settings, conflict resolution rules, and much more.
Adesso Client for Windows
Installing Adesso Client for use on your PC is quick and easy. The Adesso client installs on any Windows computer (Windows XP, Windows 7, Windows 8, Windows 8.1, Windows 10), including desktops, laptops, tablets, notebooks, and more. Once installed, you can quickly establish a connection to one or more Adesso Servers and download and synchronize your applications. Users who have been given schema designer privileges on the SyncAdmin portal for a particular Adesso application will have the ability to also edit the database schema for that application right from Adesso Client. New applications can be built right from within Adesso Client and uploaded to an Adesso Server as well.
Adesso Client for Android
Coming 1-1-2017 Adesso Client for Android operates similarly to Adesso Client for Windows, allowing you to download and sync multiple applications that your credential has permissions to access. Once an app is downloaded to Adesso Client for Android, every aspect of that application is available locally, meaning that you can use the application without an internet connection. Full bi-directional sync support means that the highly granular permissions and sync levels that Adesso is famous for are fully retained in Adesso Client for Android. This differs from most systems that offer offline support via cached XML files because Adesso can detect changes in a single column, sync in both directions, filter which records go from client to server and vice versa using SQL statements, and handle conflict resolution in one of 4 ways (3 automatic, and 1 manual), all out of the box.
Adesso Web Client
The Adesso Web Client allows you to add, edit, and delete records into your Adesso database with much of the same functionality and exact same permission structure/privileges as Adesso Client, except that it can be accessed via any web browser, even on iOS and Android-powered devices!
However, because Adesso Web Client is an online mode version, an internet connection is required. It is also a more limited version of Adesso and does not support the plugin architecture of Adesso Client.
AdessoSQL Web Services (Integration) API
Build an application in any language (.NET, Java, PHP, RoR, etc) and integrate it with your Adesso database via AdessoSQL Web Services. Using AdessoSQL Web Services, developers can run standard SQL commands against Adesso applications and receive the result in XML format.
AdessoSQL Web Services consists of a few methods to authenticate the user, retrieve schema information, and run SQL commands. It also follows the security and access control schema of Adesso and does not allow unauthorized access to the Adesso applications and tables.
Adesso ODBC Driver
Data stored locally on a user’s device or stored in Adesso Server can be accessed dynamically with the Adesso ODBC driver. This means that you can extract data from Adesso Client OR Adesso Server and pass it to an application running either locally on a device or running on a server. Example use cases:
Stored locally: Let’s say your users collect data using Adesso Client on a tablet while in a remote location. Whenever your user creates a new record, it is being stored locally on the device. Now lets say you want that user to be able to print a nicely-formatted report. He/she can do that by clicking a button on an Adesso form that calls up a plugin written in some other application (Silverlight, MFC, Crystal Report, etc), and information stored in Adesso locally is then pushed to this 3rd party application via the Adesso ODBC Driver. This is really fast, and the user usually doesn’t even notice the integration piece.
Similarly, if your field users require additional functionalities that the Adesso form builder doesn’t provide out of the box, you can build a form in another language (Crystal Report, MFC, etc), call it up when the user clicks on the “new record” button, and insert the data stored in the form fields to Adesso Client’s local storage, which is then synced later to Adesso Server.
Stored on Adesso Server: let’s say you want to build a dynamic database-driven website with data collected by your users in Adesso Client and then displaying of that data on Google maps inside your new web application. Your web application can access the data stored on Adesso Server using either AdessoSQL Web Services or via the Adesso ODBC Driver.