Data store in appian

Question

Where does Appian stores the data entered ? Is that in internal database, in-memory data base or KX data base ? Does it store to internal database and Oracle's mysql database at the same time?

aloks0189 · Answer

Hi subramaniyanjp Appian operates with two data stores: 
 
1. Primary DS: This contains the details about Appian Internal objects such as Interface, Rules etc. and their configurations. We cannot use this DS to store our Business related data. 
 
2. Secondary DS: This contains the Business Data including Transaction as well Reference Data. This is where the application specific or Business specific data gets stored. 
 
Note: These DS can be renamed during the installation, hence it's not mandatory to have your DS with the same name as mentioned above. 
 
When you talk about the Database Vendors, Appian supports working with Oracle, MySQL, Microsoft SQL Server & IBM DB2 as of v18.4. 
 
And Appian doesn't have any Internal Database in fact Appian treats Primary DB to store the object & configuration specific details.

Hope this will help you.