Process Box or Touchpoint Configuration

Property Description
Operation To select the operation type table or custom SQL query (Table / Custom SQL).
Write Mode (Table) What kind of mode we want to perform over database. For example, insert, update, delete, or upsert. Similar query is performed over the database.
Catalog (Table) Helps in selecting the catalog present in the database. Depends on the database as to how the catalog is created and used (depending on the JDBC driver, the Schema, the Catalog, or both Schema and Catalog are required).
Schema (Table) Depends on the database and the selected schema present in the database (depending on the JDBC driver, the Schema, the Catalog, or both Schema and Catalog are required).
Table (Table) Select the table on which operation need to performed.
SQL Query (Custom SQL) Helps in writing complex queries. You can pass the variables enclosed in “{}” which will be visible on the mapping screen.

In case of Table operation, the field mapping screen is generated based on the selected table type, and in case of Custom SQL type operation, the field mapping screen is generated based on the variable passed inside the {} in Custom SQL textbox.

Field name Description
Table - dynamic field This depends on the table selected in the action screen and accordingly fields will visible as per the columns existing in the database table. There are other details visible with column names like description, data type, and length of the field in the database.
Custom SQL - dynamic field Fields which are passed as variable enclosed in "{}" are visible in the mapping screen and input will passed accordingly. Similar description will be provided and values are parsed from the braces will be visible on the mapping screen.