You are currently reviewing an older revision of this page.
Q: What are the default JDBC connection pool sizes for data sources configured via the Admin Console?
A: 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
The following information is intended for Appian Cloud users:
Q: Is the data in the Appian Database (MySQL) stored in an encrypted format?
A: Yes. All the data stored in Appian Cloud is stored in an encrypted format.
Q: Can Appian Cloud set up a database connection to databases not listed in the System Requirements documentation like FileMaker Pro or Sybase?
A: No. You can integrate Appian Cloud with any of the databases supported by Appian as per the System Requirements documentation.
Q: What is the idle timeout period on the default MySQL database in Appian Cloud?
A: As of April 2018, the idle timeout is defined as 5 minutes.
Q: Can I use an external tool such as MySQL Workbench to connect to my Appian Cloud business database?
A: No. Access to the MySQL instance provided with Appian Cloud is only available through Appian or phpMyAdmin interface.
Q: Which JDBC drivers are included by default on Appian Cloud?
A: MySQL, Oracle, SQL Server and DB2.
The following information is intended for Appian on-premise users:
Q: Is it possible to integrate an on-premise Appian environment with databases not listed in the System Requirements documentation like FileMaker Pro or Sybase?
A: 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.
Q: What needs to modified on the Appian server if the primary and secondary databases get renamed?
A: The name of the primary database needs to be updated in the appian_ds.xml file located in (<JBOSS_HOME>\standalone\deployments\appian-ds.xml). 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\appian-ds.xml
This article applies to all versions of Appian.
Last Reviewed: August 2018