Changes

HowTo:Connect To Oracle With A Workflow

308 bytes added, 14:38, 23 January 2015
You have to configure the connection to the Oracle database DataSource, the InitialCatalog and you need to fill out UserName and Password.
<br/><br/>
3. Use a "CreateOLETableScope" or a "CreateOLEQueryScope" to define the table you want to fetch data from.
Configure the tablename in DisplayName.
<br/><br/>
Example Workflows:
 
Connecting to oracle DB and reading data with a CreateOLETableScope
[[File:oratest.uwf|220px|border|alt=Example Workflow|Example Workflow]]
[[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]]
<br/><br/>
 Connecting to oracle DB and reading data with a CreateOLEQueryScope[[File:oratestexample_workflow_sql_statement.uwf|220px|border|alt=Example SQL Statement Workflow|Example SQL Statement Workflow]] 
1,574
edits