3 weeks ago
Hi,
Is there any standard way of provisioning to track old and new values that performed on table directly from HANA DB level?
Thanks & Regards
Nitin
Hi
Please check the below To track old and new values in HANA DB for audit trails, you can use:
1. Change Data Capture (CDC): Implement CDC to track changes on tables. HANA provides a built-in mechanism for this.
2. Audit Logging: Enable audit logging in HANA to capture DML operations (INSERT, UPDATE, DELETE) on tables.
3. Triggers: Create database triggers to log changes in custom audit tables whenever data is modified.
4. Temporal Tables: Use temporal tables to automatically track historical data changes, if applicable.
These methods will help you maintain an audit trail for standard DB tables.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
69 | |
11 | |
10 | |
10 | |
9 | |
7 | |
7 | |
7 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.