You are currently reviewing an older revision of this page.

DRAFT KB-XXXX General FAQs related to Appian and RDBMS

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 default JDBC connection pool size on Appian Cloud ?

A: By default the connection pool size on Appian Cloud is 100 per application server per database.

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.

 

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: August 2018