How do I use the SQLUpdateReceiver?
Batch update of values in a database
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.
Receiver Parameters
The SQLUpdateReceiver requires that the following parameters be 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 one property key that a user can modify on any of its associated Domain Attributes:
-
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?'
Article Feedback: Was this helpful?
Give feedback