Insert Data via OLEDB with a Workflow
[edit]
Instructions
First you need to establish a OLE database connection to an Oracle or SQL Server database. See how to Connect To Oracle With A Workflow for details on how to connect to an Oracle database.
Once we are able to connect we start modelling the data structures we want to insert into the DB in the workflow editor.
- Use the CreateOLEOracleScope (Activity) to configure the connection.
- Place either a CreateOLETableScope (Activity) or a CreateOLEQueryScope (Activity) inside the scope acticity to define the table in which you want to insert data into.
- Use an "CreateOLERow" to insert a new datarow into the table.
- Define all the data fields you want to insert data by using "EditOLEValue" activities inside the CreateOLERow. 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".
- 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.
 | When you are using a CreateOLEQueryScope to fetch data you want to create, you have to define a valid tablename! |
| For inserting data you must not define the primary key column. Do not check the "IsPrimary" property! |
