Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

If you have trouble understanding how the action works, check the description: Scheduled task

Description

A scheduled task that allows you to rewrite data from a datasource to a database.

Requirements

One or more defined data sources that enable the data read operation.

Configuration parameters
Name of the parameterParameter typeDescriptionNotes and restrictions
Datasource id*TextId of the datasource from which the data will be rewritten. 
Database name*TextThe name of the database where the data will be saved. 
Schema name in database*TextThe schema in the database where the target table exists. 
Table name*TextName of the table in which the data will be saved. 
Parameters mappings*TextSource -> database mapping
Subsequent mappings should be separated with a comma, e.g. 
firstDatasourceColumn=firstDatabaseColumn,secondDatasourceColumn=secondDatabaseColumn
Synchronization type*TextData synchronization type.

The following types are available:

  • insert (only adds),
  • overwrite (removes all records and adds new ones),
  • upsert (add or update, if the value given in the "Key" already exists).
KeyTextThe key value of which will be checked with the "upsert" synchronization type. 

Parameter*- required field

Sample configuration

  • No labels