en:datadistributionsetupout
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
— | en:datadistributionsetupout [2021/04/09 08:40] (current) – created - external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | TitleEngTAG | ||
+ | |||
+ | |||
+ | |||
+ | < | ||
+ | |||
+ | On this page you have to specify the changes you want to detect and report with Sprinkler to the remote system. This page is populated with a list of all existing tables on the database. | ||
+ | |||
+ | {{DataDistributionSetupOUT.png}} | ||
+ | |||
+ | * Action **Toggle Visibility**: | ||
+ | * Menu [[AdvancedReplication|Menu Replicate]]: | ||
+ | |||
+ | All configurations on this page are referred to the peer shown into the field //Peer Server ID// | ||
+ | | ||
+ | **Functionalities** | ||
+ | * For each table you can choose to detect every INSERT, MODIFY, DELETE and/or RENAME transaction; | ||
+ | * On an INSERT transaction, | ||
+ | * On a MODIFY transaction, | ||
+ | * On a DELETE transaction, | ||
+ | * On a RENAME transaction, | ||
+ | * It is possible to setup one or more fields on a table to be read-only, or even the whole table; it is also provided a setup to disable the RENAME operation for a table. | ||
+ | * Every INSERT, MODIFY, DELETE, RENAME report is a single atomic operation, belonging to the same transaction of the trigger OnDatabaseInsert, | ||
+ | | ||
+ | **Important advise** | ||
+ | * < | ||
+ | * FlowFields are not considered by Sprinkler, and will not be reported under any circumstance. | ||
+ | * Fields of datatype Media, MediaSet, OemCode, OemText, TableFilter are not considered by Sprinkler at this time, and will not be reported even if modified. | ||
+ | |||
+ | For each table you can then specify: | ||
+ | |||
+ | * **Report Insertion** with possible values: | ||
+ | * blank - no INSERT operation will be reported, | ||
+ | * All Fields - all the not-blank fields (at the time of INSERT) will be reported, | ||
+ | * Some Fields - the AssistEdit button opens the [[OutFieldSelection|Fields Selection]] page for the detailed configuration: | ||
+ | |||
+ | * **Report Modification** with possible values: | ||
+ | * blank - no MODIFY operation will be reported, | ||
+ | * All Fields - all the modified fields will be reported, | ||
+ | * Some Fields - the AssistEdit button opens the [[OutFieldSelection|Fields Selection]] page for the detailed configuration: | ||
+ | |||
+ | * **Report Deletion** with possible values: | ||
+ | * blank - no DELETE operation will be reported, | ||
+ | * All Fields - only the key fields will be reported, | ||
+ | * Some Fields - the AssistEdit button opens the [[OutFieldSelection|Fields Selection]] page, but only the key fields will be reported. | ||
+ | |||
+ | * **Report Rename** - if set, every RENAME operation will be reported; only the Rec and xRec Primary Key fields will be reported. | ||
+ | |||
+ | * **Force Read-Only** - if set, any operation detected on a record will trigger an ERROR on the same transaction of the detected operation: the operation will be then reverted with a rollback. | ||
+ | * If set, the only User allowed to modify the table is the Data Distribution Service User. Note that the handling of incoming data to be insert to this table is always possible. | ||
+ | * The ERROR will be raised only if the operation is detected: this flag will not effective if all //Report Insertion//, | ||
+ | * If a table is set as Read-Only, this affects both manual and automatic operations (validations, | ||
+ | |||
en/datadistributionsetupout.txt · Last modified: 2021/04/09 08:40 by 127.0.0.1