The purpose of this article is to provide answers to general questions related to Appian and RDBMS.
Table of Contents:
What are the default JDBC connection pool sizes for data sources configured via the Admin Console?
Data sources configured via the Admin Console have the following connection pool settings:
Minimum Idle Pool = 5
Maximum Idle Pool = 200
Initial Connection Size = 0
Maximum Active Pool Size = 200
Does Appian support Multidimensional Expressions (MDX) query language?
The product currently does not support MDX queries.
Can Appian set up a database connection to databases not listed in the System Requirements documentation?
Yes. Starting in Appian 23.2, any external database supporting the JDBC protocol can be connected to via a custom JDBC Connected System.
Please note that the only supported databases remain the ones listed in the documentation.
Is the data in the Appian Database (MariaDB) stored in an encrypted format?
Yes. All the data stored in Appian Cloud is stored in an encrypted format.
What is the idle timeout period on the default MariaDB database in Appian Cloud?
As of August 2018, the idle timeout is defined as 5 minutes.
Can I use an external tool such as MySQL Workbench to connect to my Appian Cloud business database?
No. Access to the MySQL instance provided with Appian Cloud is only available through Appian or phpMyAdmin interface.
Which JDBC drivers are included by default on Appian Cloud?
MySQL, Oracle, SQL Server and DB2.
What needs to be modified on the Appian server if the primary and secondary databases get renamed?
The name of the primary database needs to be updated in the appian_ds.xml file located in (<JBOSS_HOME>\standalone\deployments). If the database was added via the Admin Console, then the appropriate change in the name needs to be made via the Admin Console.
<JBOSS_HOME>\standalone\deployments
This article applies to all versions of Appian.
Last Reviewed: November 2023