KB-1673 General FAQs related to Appian and RDBMS

Purpose

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.

The Following Information is Intended for Appian Cloud Users

Is the data in the Appian Database (MySQL) stored in an encrypted format?

Yes. All the data stored in Appian Cloud is stored in an encrypted format.

Can Appian Cloud set up a database connection to databases not listed in the System Requirements documentation like FileMaker Pro or Sybase?

No. You can integrate Appian Cloud with any of the databases supported by Appian as per the System Requirements documentation.

What is the idle timeout period on the default MySQL 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.

The Following Information is Intended for Appian On-Premise Users

Can Appian on-premise environments set up a database connection to databases not listed in the System Requirements documentation like FileMaker Pro or Sybase?

Databases not listed here are supported for use with the Query Database Smart Service, as long as the database provides a JDBC compliant database driver.

What needs to 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.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: August 2018

Related
Recommended