Hi team,
I'm planning the architecture of a new Appian Project for a new customer. The customer needs to know what are the tradeoffs of choosing the native appian cloud database (MariaDB) to store business data vs the own customer's database.
I know that exists some information about it in the documentation but I would like to know more about your practical experiences on it.
Thanks.
Discussion posts and replies are publicly visible
In general, the close the database system is, the lower the latency. Then I think this is a question of the data protection policies of that client and the overall IT architecture guidelines.
In my experience, with Appian, we do not use many of the countless database features and if you have no very specific requirements then just go with the included DB.
In case you want/need direct access, Appian provides a way to do that.
As Stefan mentioned, it would be better to understand client/customer data protection policies.
Primary questions which may come up related to data encryption, Please find the below links if it helps, related to data base encryption
https://docs.appian.com/suite/help/24.1/Appian_Cloud_Database_Encryption.html
In case of data to be encrypted at a column level you can write your own plugin or their are plugins available in app market which you can make use of it.
Hello Daniel Abbehusen The choice between Appian's built-in MariaDB and your client's own database depends entirely on their security requirements and project needs.Appian's database offers a user-friendly, secure option ideal for simpler projects where a quick setup is crucial. However, if the project involves highly sensitive data or the client has a robust existing database infrastructure, using their own database provides greater control and flexibility for complex needs. Ultimately, the best solution depends on your client's specific priorities.
Thanks for the help!
Another consideration could be data restoration.
In the cloud, everything is backed up at the same time (process and DB Data) by taking a instance snapshot. If you have an on-premise database, your DB backup could be slightly out of sync with the process data.