You are currently reviewing an older revision of this page.
Q: What is the default JDBC connection pool size for datasources configured via Admin Console ?
A: Following are the connection pool settings for datasources connected via Admin Console:
Min Idle Pool = 5
Max Idle Pool = 200
Initial Connection Size = 0
Max Active Pool Size = 200
The following information is intended for Appian Cloud users:
Q: Is the data from the Appian Database (MySQL) stored in encrypted format?
A: Yes. All the data stored on Appian Cloud is stored in an encrypted format.
Q: Can Appian Cloud setup 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 databases which come default with 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 <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