Manage and Control any Database Transaction
WisdomForce enables managing all or selective database transactions. At any point of time the organizations can be aware of what, when and how the transactional change occurred in the critical production environment:
- What production data exactly has been changed, what is the new value and at same time managing the previous value
- The date and time when the particular database transaction occurred
The Audit features in WisdomForce DatabaseSync provide with an easy and highly effective visual tool for controlling all the changes made to source database tables. In addition, user can view the metadata related to all transactions that made changes to the tables.
WisdomForce DatabaseSync with Change Data Capture (CDC) enables a data change auditing capability.
DatabaseSync allows having a log of all the changes performed on any table in the database without a performance penalty which otherwise native database audit functions or triggers would have.
The audit log can be written into text files in predefined format or into a target database table in a specific format (target log table per source log table).
Each row in the audit log represents an insert, update or delete operation on the source table with additional information identifying the transaction.




