Can we create different schemas in Appian My SQL Db.
I want to know if we can maintain tables created in MySQL in separate schema and use them in Appian - Like we name the Data Store and maintaining the data store entities in them.
But when we check from backend- All these tables are in Appian Schema.
Please let me know about this...
Discussion posts and replies are publicly visible
Hi ejass, 1) You can create separate schema for your application, But you need to configure in the admin console under data source management setting. you have to provide your schema name and test connection. 2) In data store , select the schema which you have configured in admin console, so you can publish your views and tables under schema name which you have created.
Thanks Eric G. I spent an hour trying to figure out how to create a new database other than 'Appian' so that as I create new tables in the Community Edition, I would not be seeing all of the demo tables. I am taking you to mean that I do NOT have the ability to create a new database in the Appian Cloud (which is fine). I just want to clarify as I read the document you provided the link for and did not see that explicity stated. Thanks Again!! Paul
I haven't had a chance to try Community Edition yet, but I don't think you will be able to create a new database given my understanding of how Appian is managing those instances.
Confirmed - the CE cloud database looks almost identical to that of a regular Appian Cloud instance, other than coming with several pre-populated tables.