Jump to: navigation, search

Difference between revisions of "HowTo:Insert Data via OLEDB with a Workflow"


Line 1: Line 1:
 
= Instructions =
 
= Instructions =
First you need to establish a OLEDB Connection to a Oracle Database. See how to [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.
+
First you need to establish a OLE database connection to an Oracle or SQL Server database. See how to [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details on how to connect to an Oracle database.
 
<br/><br/>
 
<br/><br/>
 
Once we are able to connect we start modelling the data structures we want to insert into the DB in the workflow editor.
 
Once we are able to connect we start modelling the data structures we want to insert into the DB in the workflow editor.

Revision as of 12:51, 23 February 2015

[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.

  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.
  3. IC Attention.pngWhen you are using a CreateOLEQueryScope to fetch data you want to create, you have to define a valid tablename!
  4. Use an "CreateOLERow" to insert a new datarow into the table.
  5. 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".
  6. 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.
  7. IC Attention.pngFor 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

Example Workflow