Skip to content
background-image background-image

catalogdb

CatalogDB Update Connector

  • Version

    3.2

  • Agent restriction

    None

  • Processing type

    Row by row

  • Multi-input step

    Not Supported

This connector allow to call stored procedure on CatalogDB database to Insert or Update entry.

Input data property DataJSON is next returned to output to property DataJSON (when output schema is assigned).

Configuration

Connection String configuration

Connection string

Input data can be obtained with input data placeholders.

${input.DbName} will be replaced by value in DbName of the very first row.

CatalogDB Connection Params configuration

Entity name

Name of inserted or updated entity. By this Entity there are called stored procedures on connected DB server.

Example

  • Customer
  • User
  • ...

Database schema name

A schema is a collection of logical structures of data, or schema objects.

dbo

Number of attempts

Number of attempts to process data. Server try to execute command as many times as number of attempts is set.

CatalogDB Update Params configuration

Return response

When checked connector is returning data to its Output otherwise Output is empty.

Input & Output Schema

Input

Input schema is optional. When input schema is selected there must be JUST one entry contained.

Catalog Update Input (ver. 1.0.1)

Column Data type Allow null Description
DataJSON JSON No Input data
Source string No Data origin based on system or application.

Output

Output schema is optional. When schema is not assigned connector return empty collection.

Catalog Update Output (ver. 1.0.4)

Column Data type Allow null Description
Code string Yes Code value from Input data DataJSON property based on Connection configuration EntityName property.
Code2 string Yes Code2 value from Input data DataJSON property based on Connection configuration EntityName property.
OriginID string No OriginID unique value of processed entry in DB (Guid).
CreatedDate string No Date of entry creation.
ModifiedDate string No Date of entry modification.
DataJSON JSON No Modified Input data based on Connection configuration EntityName property.
UpdateType string No Update type information (I - inserted, U - updated)
TaskRunID integer Yes ID of the currently executing TaskRun.

Release notes

3.2.4

  • Plugin binaries update as a result of included connector change.

3.2.3

  • Fixed shared nuget package versions.

3.2.2

  • Fixed right processing of nullable properties.