Often, the Marting Dataset will be deleted after the Datamart table has been created (e.g. from an imported Excel Spreadsheet) leaving a table in the Datamart for users to edit via the Spreadsheets modules. However, where it is desired that this table is to be updated from an alternative source, it should be noted that unless otherwise configured, the Nathean Schedule Service will drop and re-create the Datamart table each time it refreshes the Marting Dataset. Users may find that Database Triggers or Stored Procedures created or called via Post-Data Load Scripts may prove useful in the development of their desired solution.
Architecture Diagram of a User Updateable Dataset: