<br/><br/>
Once we are able to connect we start modelling the data structures we want to udpate in the workflow editor.
<br/><br/>1. Use a "CreateOLEOracleScope" Activity to configure the connection.<br/><br/>2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table you want to fetch data from.<br/>
<br/>
{{Attention|When you are using a CreateOLEQueryScope to fetch data you want to update, you '''have to''' define a valid tablename!}}
3. Iterate throw the fetched rows by using e.g. a FOR - EACH activity.<br/><br/>4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.<br/><br/>5. Define the primary key data structure by placing "EditOLEValue" activities inside the OLEEditRow. You need to specify the column name in the "DisplayName" property and the data type in the "DataType" property. Check the "IsPrimary" checkbox as this column is the key column.<br/>
<br/>
{{Attention|The primary key column "must be defined" when updating data via OLE DB.}}
6. Define the data cells you want to update by placing "EditOLEValue" activities inside the OLEEditRow. You need to specify the column name in the "DisplayName" property and the data type in the "DataType" property. Specify the new value for the cell in the evaluation property "Value".<br/><br/>