Changes
= Instructions =
# Establish a connection [[HowTo:Connect_To_Oracle_With_A_Workflow|to an Oracle]] or SQL database. Once connected, it is necessary to model the table / column definitions, of the data to be udpated, in the workflow.# Use [[Activity:CreateOLEOracleScope (Activity)|CreateOLEOracleScope]] or [[Activity:CreateOLESQLScope (Activity)|CreateOLESQLScope]] to set up the connection.
# Place either a [[Activity:CreateOLETableScope (Activity)]] or a [[Activity:CreateOLEQueryScope (Activity)]] within the scope acticity to define the table you want to udate data.
# Iterate throw the fetched rows by using e.g. a '''for each''' activity.
