Integrated Reporting

Integrated reporting with powerful grouping, sorting and computed columns – including master-detail break outs. Advanced features include:

• Computed Columns with Correlated Sub-Queries
• Advanced Join Options (e.g. Inner, Left, Right).
• Data "windowing" functions for advanced data analytics.
• Direct Export to Excel.

Powerful cloud-based Reporting without the need for a separate solution.

Easily build visual, data-rich applications.

Charts, Maps & Dashboards

A large assortment of ways to visualize your data and build rich interactive dashboards.

• Wide variety of chart types: bar, line, area, pie, doughnut, bubble, timeline, Gantt charts and geographic heat maps.
• Google Maps integration to easily render location based data.
• Interactive: click on a chart element to fire a data link to any other widget in your application (for building apps with advanced drill-down capabilities).
• Works on mobile too!

Core Business Logic

AppSynergy has built-in support for coding triggers, functions & stored procedures using a modern ANSI standard version of Oracle's PL/SQL language. This provides more powerful data manipulation capabilities with cleaner syntax and superior execution efficiency when compared with other languages. And AppSynergy extensions like SQL/REST (see below) cleanly extend this paradigm into the world of modern RESTful APIs, JSON and XML.

A better way to write business logic.

SQL/REST

AppSynergy's revolutionary SQL/REST protocol allows you to make RESTful API calls directly from your SQL code (e.g. triggers, stored procedures). Now you can call any RESTful API on the planet directly from within your SQL code. No longer are triggers and stored procedures limited to database data – they can now reach out to, and integrate with, any modern API on the planet.

Make an asynchronous API call and specify a callback procedure to process the response. There are a wide variety of functions available to easily work with JSON and XML data.

Use modern APIs to integrate with trading partners, or leverage a service like Twilio to integrate text messaging notifications into your applications. The possibilities are endless!

Asynchronous SQL/REST transforms what SQL is capable of!

Root Access

AppSynergy is based on a fully managed, enhanced version of MariaDB 10.4 – open, non-proprietary, fully scalable and standards based.

You can directly access your database from third party tools or custom applications using standard JDBC or ODBC drivers (we also offer a REST API). Access is highly secure (SSL with role based security) and unrestricted. Private, dedicated database servers are available that offer full root access and are the ultimate in terms of flexibility, privacy, security and reliability. AppSynergy is the only cloud database application platform with such an offering.

Add an event to any UI object to call your own JavaScript code.

Application API

You can easily add events to UI objects that can call your own custom JavaScript code, load libraries, and access the entire AppSynergy Application API.

The good news is you will seldom need the API as even highly complex applications are typically built entirely via drag-n-drop with a few formulas added for calculated fields. AppSynergy is that powerful.

Flexible Look & Feel

Create fully custom CSS themes and share them across multiple applications for a consistent look and feel.

There is even an HTML widget that combined with some JavaScript or a third-party library can render absolutely anything on the screen without limitation.

You have full control over your application's look & feel.

Example of multiple documents related to a particular customer record.

Extended Field Types

AppSynergy has advanced field types including document, signature and image.

• Use document fields (see right) to store an unlimited number of documents with the records they relate to. Easily find scans of paper documents related to a specific electronic record.
• Signature fields allow capture of a signature directly within your application – just like a FedEx delivery signature!
• Image fields go beyond the normal by automatically creating thumbnail images on the fly from the original source image.
• Barcode fields allow you to render data in a variety of barcode formats.

Embed An Application

You can embed an application in your website with a simple copy & paste of its embed code. Great for creating customer portals!

• Set your embedded application to public access and anyone visiting your website will have access just like a regular web page.
• Set your embedded application to private access and users will be prompted to sign in – which allows you to control exactly what information they can access.

Easily create a secure customer portal.