When adding a new column to an existing database table used by an Appian app, what is the correct sequence of steps to implement the change?

When adding a new column to an existing database table used by an Appian app, what is the correct sequence of steps to implement the change?

• A. Update the database table; Update the CDT; Save and publish data store; Verify datastore
• B. Verify datastore; Update the database table; Save and publish data store; Update CDT
• C. Update CDT; Save and publish data store; Update the database table; Verify datastore
• D. Update the database table; Update the CDT; Verify datastore; Save and publish data store

Answer: (D)

When you add a new column, you must align both the physical database and Appian’s data model before making the change active in the runtime. Start by updating the actual database table so the column exists there. Then update the CDT to reflect the new column so Appian can map that field to the table. After that, verify the datastore to ensure the CDT and database are in sync and that Appian can access the new column without errors. Finally, save and publish the data store so the change takes effect in the runtime environment. This order prevents mismatches and runtime errors that could occur if the model were updated before the database or if publishing were done without verification.

When you add a new column, you must align both the physical database and Appian’s data model before making the change active in the runtime. Start by updating the actual database table so the column exists there. Then update the CDT to reflect the new column so Appian can map that field to the table. After that, verify the datastore to ensure the CDT and database are in sync and that Appian can access the new column without errors. Finally, save and publish the data store so the change takes effect in the runtime environment. This order prevents mismatches and runtime errors that could occur if the model were updated before the database or if publishing were done without verification.