CUSTOMIZATION
TUTORIALS
RESOURCES
AppSynergy Plans | Development | Production | Enterprise |
---|---|---|---|
Price
Custom plans available |
Contact Us | Contact Us | Contact Us |
Users Included
Number of users included |
1 developer plus Test users | 10 to 100 users | 100+ users |
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
Use image fields and document fields to build apps with advanced capabilities. Store an unlimited number of images and/or documents per record. Drag and drop images and documents to store them in the database. |
✓ | ✓ | ✓ |
Electronic Signature Capture
Capture delivery signatures, etc. with signature fields. Simply sign with your finger, stylus or a mouse with a tablet, phone, etc. |
✓ | ||
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. |
✓ | ✓ |