(Glue-2311) SNP Glue™ Table Consumer
SNP Glue™ Table Consumer uses the SNP Glue™ table as a target for data.
Creation of the SNP Glue™ Table Consumer
Perform the steps outlined in How to Create a Consumer Object with the option SNP Glue™ Table Consumer selected under the Component implementation dropdown of step 4.
Activation of the SNP Glue™ Table Consumer
After creation, the object is in the saved state. For activation, all mandatory inputs need to be filled in.
- SNP Glue™ Table
- Name of the SNP Glue™ table as a target for data
- Provided with F4 help
- Enable merge
- The flag that will enable the merge operation
- It can also be enabled/disabled in the Extraction process selection screen
- Keep deleted entries
- This flag will keep deleted entries in the target table while using merge functionality.
- Enable merge must be allowed.
- If field GLREQUEST is present, this field must be not a key field.
- Deletion flag fieldname
- Only visible when the Enable merge checkbox is checked
- Name of the field that flags if the record was deleted
- Must exist in the SNP Glue™ table (can be added using the button in the Import fields screen).
- Merge timestamp
- Also visible only when the merge is enabled
- Name of the field that distinguishes when the record was inserted in the table
- Must exist in the SNP Glue™ table (can be added using the button in the Import fields screen).
It is possible to adjust the SNP Glue™ Table consumer's structure automatically when it is combined with Advanced DSO in the Extraction Process. For more information, see the chapter (Glue-2311) Automatic adjustment of Consumer structure.
Transparent storages with secondary DB
No deletion flag is required for transparent storages with a secondary DB connection. However, keeping deleted entries is also not supported.
Merge in secondary DB connection storage is handling simple operations (INSERT, UPDATE, DELETE) that are not advanced, for example, INSERT → UPDATE.
Connection to storage failed
When connection to storage failed and merge was enabled, there is a possibility to force delete merge metadata after deactivating a consumer.