You can integrate other systems with RESTful API calls from the server or application tier, and also take advantage of our federated data capabilities (250+ plug-ins available) if you need to integrate with commercial SaaS applications or other databases.
AppSynergy has the industry's most advanced relational nested object capabilities. Building editable screens that rely on multiple tables with complex relationships has never been this powerful or quick.
Records can contain scrolling lists of records, reports, etc. without limitation as to depth or complexity. 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 with powerful filtering, sorting, grouping, and computed columns – including master-detail style reports. Advanced features include:
AppSynergy provides a variety of ways to visualize your data and build rich interactive dashboards.
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.
You can also build high quality mobile optimized web apps that users can install on their mobile device for a fullscreen, browserless experience.
AppSynergy provides full root access to your own private, dedicated database server without restriction. Freely use third-party tools directly with your AppSynergy hosted MariaDB database without any artificial restrictions getting in the way.
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.
On the server-side you have full support for building out complex business logic using ANSI standard Procedural Language programming extensions to SQL. This is similar to Oracle's PL/SQL with variables, FOR, WHILE, IF, etc. plus the ability to make RESTful API calls and publish your own RESTful APIs.
Signatures fields make it easy for you to capture signatures from within your mobile applications.
Your PL/SQL code can dynamically generate HTML on the server – say, for an invoice – then make an API call to convert that HTML into a PDF document that you can store in the database.
You can send email from your PL/SQL code – including attachments from any document field in your database. So, for example, you can easily write a trigger that sends an email notification when something ships.
On the other hand, you can also receive email into your database by sending it (or cc'ing it) to SomeName@YourDomain.com. The inbound email is parsed and stored in database format – including attachments as document fields – for easy use within your application.
Explore Our Data Integration
Click here to learn more.