Nathean Analytics Spreadsheets can be configured to allow users to edit, or insert data into, a datamart table. For details on the configuration of this, see here.

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:

Revision: 3
Last modified: May 21, 2020

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment