In this example, we will use the well-known Northwind sample database to demonstrate updating customer records. We have a "Customers" table and wish to update the customer "Alfreds Futterkiste" with a new contact person and city.
-
Configure the Oracle Update Snap with the Table name property set to "Customers".
-
Set the Update condition property to CustomerName='Alfreds Futterkiste' to target the specific customer record.
-
Provide input data with the new ContactName and City values to the Update Snap.
-
Run the pipeline to submit the update request to the database server and verify the customer record has been updated.