Description

The SQLUpdateReceiver connects to a database and performs batched updates. This Receiver is useful for data replacement of values within a database table to guarantee data security.


In This Article


Receiver Parameters

The SQLUpdateReceiver requires that the following parameters are defined:

  • resourceName - Defines the path and name of the resource that contains the database connection information on a user's local machine.

Receiver Attribute Property Keys

The Receiver defines two property keys that can be modified on any of its associated Domain Attributes:

  • columnName - Defines the name of the column as it is in the actual database table.
  • variable - Determines if the Attribute will be used as a variable within the update statement. Up to 20 attributes may be assigned to a variable (var1 - var20). The default is 'noVar', meaning the attribute will not be used.


Defining an SQL Update statement

The update statement is defined on the Receiver's 'Data' tab.  


Example SQL Update Statement


Attributes whose values will be used in the update statement are assigned a variable from var1 to var20.



JDBC Configuration File

This Receiver utilizes a configuration file stored locally on the user's computer or a shared test server to obtain the necessary information to connect to a specific database via JDBC. For detailed information, refer to 'What is a JDBC Config File?'