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 11 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*TextMapping the output parameters from data source to the corresponding column names from the database table.

Parameter mapping formula:

<dataSourceParameter>=<TableColumn>

Subsequent mappings should be separated by a comma, e.g.

<dataSourceParameter1>=<TableColumn1>,<dataSourceParameter2>=<TableColumn2>

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

Data from the data source will not be successfully written to the database table if the returned values do not match the defined table column types.

Sample configuration

  • No labels