Introduction Appian's data fabric allows you to unify, secure, and optimize data spread across the enterprise. Typically, writing and syncing data in record types is as easy as using one of Appian’s smart services like Write Records, Write to Data Store…

This guide will walk you through adding simple error handling to a stored procedure created in the Appian cloud database (MariaDB), allowing you to capture errors and warnings. Refer to the official documentation for your database if you're using one…

Overview Embedded interfaces can provide solutions for Appian customers for a variety of reasons. One such use case involves a customer that has an existing external facing portal with branding and legacy functionality that they currently direct their…

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…

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…

The document provides a list of best practices applicable to debugging interface performance and errors. For more information view the SAIL Performance documentation. Debugging Interface Performance Issues The first step to diagnosing any performance…

Appian can generate documents to present data in a specific file format. Depending on your formatting needs and the number of documents that need to be generated there are several approaches to consider. Alternatives to Generating Documents First…

Overview Over time, user accounts need to be created, updated, and deactivated. Customers who have an existing user directory can use the LDAP Tools plug-in to automatically mirror these changes to Appian without requiring users to work manually through…

Testing is vital to ensure that only high-quality projects are produced. Throughout the application's lifecycle, testing strategies can be categorized into the following stages: Before development During development Leading up to go-live During…

Data Types In Appian you can store a point in time using a variable with a Date and Time data type, which differs from the Date data type and the Time data type. Date DateTime Time How is it saved in the database…

General Guidance This page explains how to create a process to assign tasks in bulk. Many of the recommendations follow general Appian best practice on using memory-efficient process models . Do Take advantage of Appian's ability to balance engine…

Skills Covered Appian Records bring together all important and relevant enterprise data into a searchable collection of information. When you leverage Appian Records, each row of source data is displayed as a record in Appian. But a record is more than…

Overview Reference data is static data that is used to classify or categorize other data. Examples of reference data include diagnostic codes , state names, supplier industry codes , and product codes. Storing reference data in a lookup table allows…

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…