Insert Data via OLEDB with a Workflow

[edit]

• Instructions
• Example

Instructions

First you need to establish a OLEDB Connection to 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 insert into the DB in the workflow editor.

1. Use the CreateOLEOracleScope (Activity) to configure the connection.
2. 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.

When you are using a CreateOLEQueryScope to fetch data you want to create, you have to define a valid tablename!

3. Use an "CreateOLERow" to insert a new datarow into the table.
4. 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".
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.

For inserting data you must not define the primary key column. Do not check the "IsPrimary" property!

Example

Connecting to oracle DB and creating data : Example Workflow ORACLE INSERT STATEMENT.uwf