Create new database user in Appian Cloud Database

Question

Hi All, 
 
 I was wondering if I can create new database user on Appian MySQL, the reason why, I want to create read only user for abstracting data from MySQL to third party. 
 
 Thank you.

Peter Lewis · Answer

The best way to do this is through the Enhanced Data Pipeline . Appian support will create a new read-only user that you can then you to connect to Appian data from external systems.

Carlos Santander · Answer

Are you asking about having a user from outside of Appian access the MySQL Cloud database? Outside of the Enhanced Data Pipeline that Peter Lewis mentioned, you can't establish something like a direct JDBC connection to that database. An alternative would be to set up a VPN connection to an external database and keeping your Appian data there.

Peter Lewis · Answer

No the enhanced data pipeline is only for forwarding the data to an external system. However, there is actually a new feature released in 21.3 that allows you to define additional schemas in Appian Cloud and limit the access for users to those databases: docs.appian.com/.../appian-cloud-database-administration.html