Maintain Data Vault history and active record

Is it possible with outsystems to maintain a Data Vault database?

Is it possible to maintain versions of the same element with an outsystems flow?

P.e. I want to update an entity "project" with a change in a row:


Database status (before the action):
id - pr_name - description - load_date - end_date
1  - "project 1" - "old text" - 2019-02-03 - null    << active record

Update:
pr_name - description
"project 1" - "new text"


Database status (after the action):
id - pr_name - description - load_date - end_date
1  - "project 1" - "old text" - 2019-02-03 - 2020-06-12

1  - "project 1" - "new text" - 2020-06-12 - null    << active record



Note: I still have not decided if use an external database or not.



I think my question is highly related to this very old one:

https://www.outsystems.com/forums/discussion/2699/keep-history/

Hello Pablo,

Yes, of course it is possible to create a data vault database with OutSystems.

You'll need to create another entity for that purpose. It can be a generic one that suits all of your entities or a specific one for your Project entity. It really depends which information you want to keep.

If it's only for your Project entity, I suggest that you create an entity ProjectHistory (for example). And basically, everytime you create or update a record in the Project entity, you need to reflect those changes in your ProjectHistory entity as well.

This way will allow you to maintain the track of your changes.


Hope it helps.


Kind regards,

Rui Barradas