Changes
Created page with "First you need to establish a OLEDB Connection t o a Oracle Database. See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details. <br/><br/> Once we are able to connect we st..."
First you need to establish a OLEDB Connection t o a Oracle Database.
See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.
<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.
<br/>
1. Use a "CreateOLEOracleScope" Activity to configure the connection.<br/>
2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table in which you want to insert data into.<br/>
<br/>
{{Attention|When 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.<br/>
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".<br/>
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/>
{{Attention|For inserting data '''you must not''' define the primary key column. Do not check the "IsPrimary" property!}}
'''Example Workflows:'''
<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/>
[[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]
<br/><br/><br/>
[[Category:How-To]]
[[Category:Workflow]]
[[Category:UBIK Studio]]
[[Category:Activities]]
[[Category:Interfacing]]
[[Category:OLE]]
See [[HowTo:Connect_To_Oracle_With_A_Workflow]] for details.
<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.
<br/>
1. Use a "CreateOLEOracleScope" Activity to configure the connection.<br/>
2. Place either a "CreateOLETableScope" or a "CreateOLEQueryScope" inside the scope acticity to define the table in which you want to insert data into.<br/>
<br/>
{{Attention|When 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.<br/>
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".<br/>
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/>
{{Attention|For inserting data '''you must not''' define the primary key column. Do not check the "IsPrimary" property!}}
'''Example Workflows:'''
<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/>
[[File:UI_Activity_InsertViaOLEDB.PNG|440px|border|alt=Example Workflow|Example Workflow]]
<br/><br/><br/>
[[Category:How-To]]
[[Category:Workflow]]
[[Category:UBIK Studio]]
[[Category:Activities]]
[[Category:Interfacing]]
[[Category:OLE]]
