Rapid Web App Development

AppSynergy was designed specifically for building powerful cloud-based business applications. With modern, model-driven drag-n-drop techniques used for virtually everything - and a clean transition to code when required - development is super rapid.

Simply drag objects like tabs, menus, buttons, records, reports, charts, modal panels and more from the palette and drop them into your application canvas. Nest related record objects to easily create complex screens that use multiple related tables. Create a data link from one object to another to show related info on other screens or modal panels. Build desktop apps and mobile optimized web apps all with the same platform. Full programmability on both client-side and server-side means you'll have the power to build even the most complex systems, while using easy drag-n-drop for everything routine. Less code. Less headaches. Better apps.

Rapidly build solutions that meet your specific business requirements.

Infinitely Nestable Records

Nested Relational Records

AppSynergy has the industry's most advanced relational nested record capabilities. Building editable screens that rely on multiple tables with complex relationships has never been this powerful or easy.

Records can contain scrolling lists of records (which can contain other records, etc.) without limitation as to depth. The records can be free-form tabular, form-like, multi-line, etc. – you have complete layout freedom. Calculated fields can occur at any level, and parents can sum over child values. Changes to child values automatically ripple through to peer, parent, and child formulas with no additional work.

Integrated Reporting

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

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

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

Quickly build highly visual, data-rich applications.

Data Visualization

AppSynergy provides a variety of ways to visualize your data and build rich interactive dashboards.

Google Maps integration to easily show location based data.
Multiple Chart Types: bar, line, area, pie, doughnut, bubble, timeline, Gantt charts and geographic heat maps.

All charts support data linking and live interaction. For example, clicking on a chart element or map pin can bring up related information from the database.

Mobile Optimized Web Apps

You can easily create mobile optimized applications that leverage all of AppSynergy's powerful features (its not just a "lite" version). A mobile optimized app can be installed on your mobile device (via Add to Homescreen) so that a single click of an icon on your phone or tablet can launch an app in full screen mode without the browser being visible in any way.

Only write code when absolutely necessary.

Programmability

AppSynergy provides robust support for both client-side and server-side programming.

On the client-side, a complete Application API allows your custom JavaScript code to integrate tightly with all the widgets in your drag-n-drop built UI. Just add an event and a little code to do whatever is needed – without reinventing the wheel.

On the server-side you have full support for ANSI standard Procedural Language programming extensions to SQL (PL/SQL). This provides full programming support in addition to SQL, with all the standard language constructs you would expect (e.g. the ability to declare variables/functions/procedures, looping, IF-THEN-ELSE, a huge function library, etc.) All provided within the AppSynergy UI to make it easy to use.

RESTful APIs

The modern world runs on RESTful APIs. AppSynergy has full support for making server-based, secure outbound web requests to any JSON based RESTful API. You can also securely receive inbound web requests with nothing more than an API key.

Outbound Web Requests – Call any REST API directly from your PL/SQL code. Easily call from triggers, functions, stored procedures or scheduled events.
Inbound Web Requests – Receive inbound RESTful API calls to your server and process as needed. Easily publish secure APIs for others to use.

BEGIN

	IF (NEW.resp_code IS NULL) THEN
		
		IF (JSON_VALUE(NEW.req_params,'$.TestMe') = 'true') THEN

			SET NEW.resp_code = 200;
			SET NEW.resp_body = JSON_OBJECT('MyResponse','Hello World');

		ELSE

			SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Invalid Request';		

		END IF;

	END IF;

END

Easily process inbound web requests.

Root Access

AppSynergy provides full root access to your own private, dedicated database server without restriction.

This means you can integrate third-party tools and applications with ease. Quickly connect via any software that supports MariaDB, MySQL, ODBC, JDBC or REST APIs.

Open SQL Database

Click here to learn more about AppSynergy's unrestricted root access to your own dedicated database server using standard tools and technologies.

Create your own fully custom Security Roles

Role Based Security

Every user is assigned to a Security Role and authenticated at both the application layer and the database layer.

You can easily create fully custom Security Roles to specify exactly which tables and fields a user can view or modify. Further, your application UI can reference the currently logged in user and/or role to dynamically change the UI as needed, filter visible rows based on the current user or their role, etc.

Electronic Signatures

AppSynergy has built-in electronic signatures fields. Now you can easily capture electronic signatures directly from within your application (e.g. like a FedEx delivery signature).

Capture signatures directly from within your applications.

Integrated Support for Barcodes

Barcode Support

Of course you can easily scan barcodes using any commercially available barcode scanner. But AppSynergy also has the ability to generate barcodes from data in over 15 different formats for use on printouts like packing slips and inventory labels.

Embed An Application In Your Website

Embeded App Support

You can embed your application into your website with a simple copy & paste of an embed code.

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. Great for B2B customer portals!
Set your embedded application to public access and anyone visiting your website will have access just like a regular web page. Great for easily enhancing websites with live data!

Email Integration

AppSynergy has integrated email APIs for easily sending email notifications and receiving email back into the database. We use SendGrid as our email transport partner.

Outbound Email. Easily send an email notification with a single line of PL/SQL code. Full support for advanced scenarios like capturing a status change on an order, dynamically generating an HTML invoice, converting that into a PDF document, storing it in the database and finally sending it as an email attachment.
Inbound Email. Easily receive email into your database by simply cc'ing AnyName@YourDomain.com The email is parsed and stored in database format for easy use within your applications.

Integrated capabilities for sending and receiving email.

Programmatically create PDF documents from database data.

PDF Generation

AppSynergy has server-side PDF doc generation capabilities built in – making it easy to build systems that need PDFs generated for things like invoices, purchase orders, customs documents, etc. Your PL/SQL code can call three types of PDF services:

HTML2PDF – Converts your dynamically generated HTML (e.g. for an invoice) into a PDF without user intervention.
PDF_AUTOFILL – Inserts database data into a fillable PDF template (e.g. a customs form) generating a complete PDF without user intervention.
PDF_MERGE – Combine multiple PDFs into a single document.

Next Step

Explore Data Integration Features

Click here to learn more.