Introduction In version 22.1 Appian released support for executing stored procedures out-of-the-box using a!executeStoredProcedureForQuery() , a!executeStoredProcedureOnSave() , or the Execute Stored Procedure Smart Service . With this release, the…

Introduction This is intended to focus on the migration of data from existing applications to a new Database Schema in the MariaDB cloud database. The following sections of this article outline the recommended steps for migrating all or part of your…

Introduction Are you having trouble finding data to debug an issue? Are your queries to a transaction table slow? Did you get a requirement to display activity history for a user? Your Appian application’s data model design and data deletion strategy…

Can Appian integrate with my database The list of supported databases and versions can be found in the System Requirements . Supported databases can utilize out-of-the-box functionality to query and update data: Write Records Smart Service Write…

Certain Appian applications are a mix of transaction heavy OLTP (Online Transaction Processing) - with a high volume of insert, update and delete transactions and read-heavy or CPU intensive OLAP (Online Analytical Processing) with reporting and analytical…

Database hosting considerations for Appian Cloud customers For Appian Cloud customers, data generated by Appian applications can be stored in the following locations: The MariaDB database included with the Appian Cloud site One or more supported…

This article discusses methods for achieving field level auditing. That is, how to keep records of changes to any field in a table, including who made the change and when. The main engineering guidance on auditing can be found here . Table Structure…

This page describes the recommended approach to database operations with slow execution phases, which is the case if: The database is identified as the root cause for a slow interface (possibly using the Interface Performance and Debugging section…

This guide deals with writing database scripts which can be rerun (‘rerunnable’). Creating rerunnable scripts makes deployments easier and avoids any unwanted behavior if the code were to run more than once. When modifying or updating a database, running…

The document provides a list of best practices applicable to database query performance. See also Introduction to Query Optimization and SAIL Performance Tuning . Performance Considerations Reduce the Size of the Response The more data the database…

This play provides an introduction to database query optimization. As a general recommendation, design your applications using Appian Records with Data Sync enabled . The Data Sync feature caches your source data in Appian and provides the Appian Data…

Database Volume Testing Database Volume Testing is used to test and determine the amount of real-time data your database can handle efficiently without any performance issues. It is also an indicator of any scalability issues that may arise once the…

Database Views As a general recommendation, design your applications using Appian Records with Data Sync enabled. The Data Sync feature provides the ability to relate and transform data using record relationships and custom record fields, even across…