How to use Onesait delete destination

Description

Dataflow’s Onesait Delete destination stage deletes information of the configured ontology.

Importing to the pipeline look for Delete in the stages palette like this:

Drag and drop to the panel.

Once imported, it can be configured to achieve different behaviours depending on the case.

This tab shows general information and an option to show the event generator point on the stage

Checking the "Produce Events" option the stage shows another point to make usage of the events.

The events triggered are:

Document deleted
- Which sends the deleted records in a list (data-deleted)
Document not deleted
- Which sends the not deleted records in a list (data-not-deleted)

Example data deleted:

This tab shows a form to fill with the Digital Broker information of the Onesait platform.

This tab shows the main form of the stage. It can be configured to use sql sentences.

ThreadPool: number of thread to execute.

Generate error when no records are deleted: Generates an error if no records are deleted

Filtering fields: Fields used to perform the filter of delete operation.

Use SQL: change mode to SQL sentence.

Query: SQL Query to delete data.