HowTo:Insert Data via OLEDB with a Workflow - Revision history

KNO: /* Example */

2015-05-20T09:17:44Z

‎Example

KNO: /* Example */

2015-05-20T09:17:08Z

‎Example

KNO: /* Example */

2015-05-20T09:04:30Z

‎Example

KNO at 09:04, 20 May 2015

2015-05-20T09:04:11Z

KNO at 12:51, 23 February 2015

2015-02-23T12:51:29Z

KNO at 12:43, 23 February 2015

2015-02-23T12:43:31Z

KNO at 12:30, 23 February 2015

2015-02-23T12:30:56Z

KNO at 12:30, 23 February 2015

2015-02-23T12:30:22Z

KNO at 12:16, 23 February 2015

2015-02-23T12:16:06Z

KNO at 11:57, 23 February 2015

2015-02-23T11:57:29Z

@@ Line 16: / Line 16: @@
 Connecting to oracle DB and creating data
 {{FileLink|Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|Download Workflow example}}
 [[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]
 [[Category:How-To|Insert Data via OLEDB with a Workflow]]
 [[Category:OLE|Insert Data via OLEDB with a Workflow]]

@@ Line 14: / Line 14: @@
 = Example =
-Connecting to oracle DB and creating data : {{FileLink|Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|Example Workflow}}
+Connecting to oracle DB and creating data
 <br/><br/>
 [[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]

@@ Line 14: / Line 14: @@
 = Example =
-Connecting to oracle DB and creating data : {{FileLink:Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|Example Workflow}}
+Connecting to oracle DB and creating data : {{FileLink|Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|Example Workflow}}
 <br/><br/>
 [[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]

@@ Line 14: / Line 14: @@
 = Example =
-Connecting to oracle DB and creating data : [[File:Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|220px|border|alt=Example Workflow|Example Workflow]]
+Connecting to oracle DB and creating data : {{FileLink:Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|Example Workflow}}
 <br/><br/>
 [[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]
 <br/><br/><br/>
-[[Category:OLE]]
+[[Category:How-To|Insert Data via OLEDB with a Workflow]]
-[[Category:How-To]]
+[[Category:OLE|Insert Data via OLEDB with a Workflow]]

@@ Line 1: / Line 1: @@
 = 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/>
 Once we are able to connect we start modelling the data structures we want to insert into the DB in the workflow editor.

← Older revision		Revision as of 12:16, 23 February 2015
Line 1:		Line 1:
		+
		+	= Instructions =
	First you need to establish a OLEDB Connection t o a Oracle Database.		First you need to establish a OLEDB Connection t o a Oracle Database.
	See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.		See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.

@@ Line 3: / Line 3: @@
 <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.
-. Use an "CreateOLERow" to insert a new datarow into the table.
+<ol>
-<br/><br/>
+<li>Use the [[Activity:CreateOLEOracleScope (Activity)]] to configure the connection.</li>
-. 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".
+<li>Place either a [[Activity:CreateOLETableScope (Activity)]] or a [[Activity:CreateOLEQueryScope (Activity)]] inside the scope acticity to define the table in which you want to insert data into.</li>
-<br/><br/>
+{{Attention|When you are using a CreateOLEQueryScope to fetch data you want to create, you '''have to''' define a valid tablename!}}
-. 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.
+<li>Use an "CreateOLERow" to insert a new datarow into the table.</li>
-<br/>
+<li>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".</li>
 {{Attention|For inserting data '''you must not''' define the primary key column. Do not check the "IsPrimary" property!}}
-'''Example Workflows:'''
+= Example =
-<br/><br/>
 Connecting to oracle DB and creating data : [[File:Example_Workflow_ORACLE_INSERT_STATEMENT.uwf|220px|border|alt=Example Workflow|Example Workflow]]
 <br/><br/>