Difference between revisions of "HowTo:Update Data via OLEDB with a Workflow"
| Line 11: | Line 11: | ||
3. Iterate throw the fetched rows by using e.g. a FOR - EACH activity.<br/> | 3. Iterate throw the fetched rows by using e.g. a FOR - EACH activity.<br/> | ||
4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.<br/> | 4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.<br/> | ||
| − | 5. Define the primary key data structure by placing "EditOLEValue" activities inside the OLEEditRow. | + | 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/> | <br/> | ||
{{Attention|The primary key column "must be defined" when updating data via OLE DB.}} | {{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. | + | 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/> |
Revision as of 08:12, 29 January 2015
First you need to establish a OLEDB Connection t o a Oracle Database.
See Connect To Oracle With A Workflow for details.
Once we are able to connect we start modelling the data structures we want to udpate in the workflow editor.
1. Use a "CreateOLEOracleScope" Activity to configure the connection.
2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table you want to fetch data from.
 | 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.
4. Once you found the row you want to update, use an "OLEEditRow" to make it editable.
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.
| 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".
Example Workflows:
Connecting to oracle DB and reading data with a CreateOLETableScope: Example Workflow ORACLE UPDATE STATEMENT.uwf
