New Features
Delete type
Two delete type options, hard and soft, were added. There is also an option to filter soft deletes from merge view.
Merge
Now there is an option to trigger merge based on current delta size.
Merge objects
There is an option to split generated merge objects (merge table, stream, view, task) into their respective schemas.
Staging tables
Added housekeeping option to cleanup old data from staging tables.
Added option to transfer already existing tables into the native application.
Statistics
Now merge runtime information is captured and can be viewed in new statistics screen.
Improvements
Application roles
Created sub-roles for SNP_GLUE_SAP role for each merge object types for better permission granularity.
Installation
Removed last manual SQL query execution needed for successful application installation and initial setup.
Merge objects
Propagated table fields comments from stage table to merge view and merge table.
Added option to customize suffixes for all merge objects.
Fixes
Table creation
Fixed table field description cutoff and it’s related bug that caused issues when creating a table.