You are currently reviewing an older revision of this page.

DRAFT KB-XXXX General FAQs related to Appian and RDBMS

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: Is it possible to integrate an on-premise Appian environment with databases not listed in the System Requirements documentation ?

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: The Database Administrator has renamed the primary and secondary databases. What needs to modified on the Appian server to point to the renamed database? 

A: The name of the primary database needs to be updated in the <Appian_Home>\bin\jboss-eap-6.4.0\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.

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

Affected Versions

 

This article applies to all versions of Appian.

Last Reviewed: August 2018