FEATURES
TUTORIALS
PRICING
RESOURCES
AppSynergy Plans | Starter | Business | Enterprise |
---|---|---|---|
Price
Custom plans available |
FREE | Contact Us | Contact Us |
Users Included
Number of users included |
1 developer | 10 - 100 | 100+ |
Additional Users
Price per additional user |
$29/month | Contact Us | Contact Us |
Server Type
Shared Test Server or Private, Dedicated Server for production use. |
Shared | Dedicated | Dedicated |
Core Capabilities
Best In Class features. |
|||
Drag & Drop App Development
Quickly build powerful, enterprise-grade business applications. Position and tweak everything in the layout editor. Join tables, link objects, define filters, create formulas, etc. |
✓ | ✓ | ✓ |
Advanced Reporting
Create master-detail style "roll up" reports with multiple tables, computed columns, sub-queries, grouping, sorting, multiple filters, data windowing and more. |
✓ | ✓ | ✓ |
Data Visualization
Over a dozen chart types (e.g. bar, line, pie, scatter, geo, heat map, etc.) plus Google Maps for working with location based data. |
✓ | ✓ | ✓ |
Mobile Apps
Build quality, browser-based mobile apps. Apps can be installed on the mobile device's home screen for one-click access. |
✓ | ✓ | ✓ |
Images, Documents & Signatures
Use image fields, document fields and signature fields to build apps with advanced capabilities. Store an unlimited number of images, documents or signatures per record. Drag and drop images and documents to store them in the database. Sign signature fields with your finger, stylus or a mouse. |
✓ | ✓ | ✓ |
Barcode Scanning & Printing
Easily integrate the scanning of 1D and 2D barcodes into your apps using your mobile device's camera or a third-party hardware scanner. Support for generating and printing QR codes and barcodes in over a dozen formats. |
✓ | ✓ | ✓ |
Fully Customizable UI
Customize the look and feel of objects easily via the toolbar, or have complete control by creating your own unique CSS style sheets. |
✓ | ✓ | ✓ |
Role-Based Security
Create custom roles to apply security with fine-grained precision. |
✓ | ✓ | ✓ |
Single Sign On
Integrated with Google Accounts sign on; no new passwords, robust two-factor authentication, supports sharing apps with internal and external users, fully secure. Uses your existing business email address (not a gmail address). |
✓ | ✓ | ✓ |
Developer Features
Write JavaScript code to enhance the UI and PL/SQL code on the server to manage data. Make API calls from either. |
|||
Application API
Full client-side JavaScript API that integrates cleanly with your drag-n-drop built application objects. Provides complete freedom to add whatever UI functionality you need so you are not limited by the platform. |
✓ | ✓ | ✓ |
PL/SQL
Server-side procedural language programming features similar to Oracle (e.g. variables, branching, loops, functions, etc.). Provides a clean way to implement advanced capabilities without introducing the complexities of a three-tier architecture. |
✓ | ✓ | ✓ |
Triggers
Fire custom PL/SQL code as a result of an INSERT, UPDATE or DELETE operation. |
✓ | ✓ | ✓ |
Stored Procedures & Functions
Write server-side stored procedures and functions in PL/SQL, including AppSynergy enhancements like API calling, email notifications, PDF generation, etc. |
✓ | ✓ | ✓ |
Database Views
Create and edit database VIEWs to centralize calculated values and or implement row-level security. |
✓ | ✓ | ✓ |
SQL Console
Issue any SQL command directly to the database via the built-in SQL console. |
✓ | ✓ | ✓ |
Server Features
AppSynergy runs on the latest stable version of the MariaDB SQL database. |
|||
Private Dedicated Server
Fully private dedicated database server. |
✓ | ✓ | |
Root Access
Full root access to the underlying SQL database; no artificial restrictions. |
✓ | ✓ | |
Command Line Tools
Use standard MariaDB command line tools on your local machine to remotely connected to your AppSynergy hosted database server. Backup, restore, issue SQL commands, etc. |
✓ | ✓ | |
Native ODBC & JDBC Support
Access your private database server via any application or tool that supports ODBC or JDBC using the standard MariaDB drivers. |
✓ | ✓ | |
API Keys
Securely expose just a portion of your database with an easily managed API Key. |
✓ | ✓ | |
Data Integration
Integrate with other SaaS solutions, APIs and databases. |
|||
Link to External Data
Link to enterprises databases, SaaS applications and APIs using AppSynergy's Federated Database features. |
✓ | ||
Make API calls from your Server
Make RESTful API calls from your triggers and stored procedures. |
✓ | ||
Publish APIs & Webhooks
Publish your own API to accept inbound RESTful API calls that you can respond to with PL/SQL. Also supports JSON webhook integrations. |
✓ | ||
EDI Toolkit
SFTP upload and download, X12 generation and parsing. Private SFTP server. Private AS2 server with MDN and TLS support. |
✓ | ||
Cron Jobs
Execute code at predetermined intervals. |
✓ | ||
Audit Trail
Support for System Versioned Tables to automatically log all changes to your database. |
✓ | ||
Services
Important features for a comprehensive solution. |
|||
Inbound Mail
Send email to your database, including attachments. Received email can be processed with PL/SQL to automate workflows. |
✓ | ✓ | |
Outbound Mail
Send email from your database via PL/SQL code, including attachments. Integrates with your SendGrid account. |
✓ | ✓ | |
PDF Generation
Dynamically generate server-side HTML and convert it to a PDF document, or auto fill PDF templates with database data. Ideal for invoicing, purchase orders, customs documents, etc. |
✓ | ✓ | |
App Embed - Public
Embed an AppSynergy application into your website and allow anyone to access it without signing in. Ideal for easily publishing live inventory data on your website. |
✓ | ✓ | |
App Embed - Private
Embed an AppSynergy application into your website while still requiring sign-in for secure access. Ideal for secure customer self-service portals. |
✓ | ✓ | |
Data Integrity
Fully managed infrastructure with transactional integrity. |
|||
Fully Managed Server
Fully managed security patching at the operating system and database level, including managed upgrades for all minor and major MariaDB release versions without customer intervention. |
✓ | ✓ | ✓ |
Transaction Processing
Fully integrated COMMIT and ROLLBACK of transactions. |
✓ | ✓ | ✓ |
Automatic Nightly Backups
Complete backups performed nightly; copies replicated to multiple physical data centers. |
✓ | ✓ | ✓ |
Backup Retention Period
Ability to recover well into the past. |
1 month | 3 months | 12 months |
Support
Premium support provided by knowledgeable staff. |
|||
Silver | Gold | Platinum | |
Hours | 10AM-6PM EST | 10AM-6PM EST | 24/7 Available |
Location | USA | USA | USA |
Response Time | 24HR | 4HR | 4HR (Urgent <1HR) |
Channels | Email, Screen Share by Apt | Email, Screen Share by Apt, Phone | |
SLA
Covered by a Service Level Agreement. Historical uptime exceeds 99.999%. |
✓ | ✓ | |
HIPAA Compliant
Full HIPAA compliance with signed BAA. Supports securely storing PHI in the database. |
✓ | ✓ |