HowTo:Connect To Oracle With A Workflow - Revision history

KNO: /* Example */

2015-05-20T09:17:27Z

‎Example

KNO: /* Example */

2015-05-20T09:16:48Z

‎Example

KNO at 09:03, 20 May 2015

2015-05-20T09:03:30Z

KNO: /* Example */

2015-05-20T08:54:15Z

‎Example

KNO: /* Example */

2015-05-20T08:35:41Z

‎Example

KNO: /* Example */

2015-02-23T11:55:27Z

‎Example

KNO at 11:54, 23 February 2015

2015-02-23T11:54:39Z

KNO at 10:03, 12 February 2015

2015-02-12T10:03:41Z

KNO at 10:03, 12 February 2015

2015-02-12T10:03:30Z

KNO at 10:01, 12 February 2015

2015-02-12T10:01:14Z

@@ Line 29: / Line 29: @@
 =Example=
 Connecting to an Oracle database and fetching data with the [[Activity:CreateOLETableScope (Activity)]]<br />
 {{FileLink|oratest.uwf|Download Workflow example}}
 Connecting to oracle DB and reading data with a CreateOLEQueryScope
 {{FileLink|example_workflow_sql_statement.uwf|Download Workflow example using a SQL Statement}}
 [[Category:How-To|Connect To Oracle With A Workflow]]
 [[Category:OLE|Connect To Oracle With A Workflow]]

@@ Line 30: / Line 30: @@
 Connecting to an Oracle database and fetching data with the [[Activity:CreateOLETableScope (Activity)]]<br />
 [[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]]<br />
-{{FileLink|oratest.uwf|Example Workflow}}
+Connecting to oracle DB and reading data with a CreateOLEQueryScope
+{{FileLink|example_workflow_sql_statement.uwf|Download Workflow example using a SQL Statement}}
-<br/><br/><br/>
-−
-Connecting to oracle DB and reading data with a CreateOLEQueryScope: [[Media:example_workflow_sql_statement.uwf|Example SQL Statement Workflow]]
 <br/>
 [[Category:How-To|Connect To Oracle With A Workflow]]
 [[Category:OLE|Connect To Oracle With A Workflow]]

@@ Line 30: / Line 30: @@
 Connecting to an Oracle database and fetching data with the [[Activity:CreateOLETableScope (Activity)]]<br />
 [[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]]<br />
 {{FileLink|oratest.uwf|Example Workflow}}

← Older revision		Revision as of 08:54, 20 May 2015
Line 32:		Line 32:

	[[Media:oratest.uwf\|Example Workflow]]		[[Media:oratest.uwf\|Example Workflow]]
		+
		+	{{FileLink\|oratest.uwf\|Example Workflow}}

	<br/><br/><br/>		<br/><br/><br/>

@@ Line 31: / Line 31: @@
 [[File:ora_example_worfklow.JPG|440px|border|alt=Example Workflow|Example Workflow]]<br />
-[[File:oratest.uwf|220px|border|alt=Example Workflow|Example Workflow]]
+[[Media:oratest.uwf|Example Workflow]]
 <br/><br/><br/>
-Connecting to oracle DB and reading data with a CreateOLEQueryScope: [[File:example_workflow_sql_statement.uwf|220px|border|alt=Example SQL Statement Workflow|Example SQL Statement Workflow]]
+Connecting to oracle DB and reading data with a CreateOLEQueryScope: [[Media:example_workflow_sql_statement.uwf|Example SQL Statement Workflow]]
 <br/>
-[[Category:OLE]]
+[[Category:How-To|Connect To Oracle With A Workflow]]
-[[Category:How-To]]
+[[Category:OLE|Connect To Oracle With A Workflow]]

@@ Line 2: / Line 2: @@
 = Instructions =
-# Configure the Oracle server in the TNS Names of your Oracle client:
+<ol>
-## Locate the file ''tnsnames.ora'' in the directory '''[ORACLESOFTWARE]\network\admin\'''
+<li>Configure the Oracle server in the TNS Names of your Oracle client:
-## Configure the connection and call it (like in this example TESTDB):<br/>
+* Locate the file ''tnsnames.ora'' in the directory '''[ORACLESOFTWARE]\network\admin\'''
 <source lang="text">
 TESTDB=
@@ Line 16: / Line 17: @@
+)
 </source>
-# Use the [[CreateOLEOracleScope (Activity)]] activity to configure the connection via the arguments:
+</li>
 #* the Oracle database '''DataSource'''
 #* the '''InitialCatalog'''
 #* '''UserName''' and '''Password'''
-# Use the [[CreateOLETableScope (Activity)]] activity or a [[CreateOLEQueryScope (Activity)]] to define the table you want to fetch data from. Set the tablename in the '''DisplayName''' argument.
+<li>Use the [[Activity:CreateOLETableScope (Activity)]] activity or a [[Activity:CreateOLEQueryScope (Activity)]] to define the table you want to fetch data from. Set the tablename in the '''DisplayName''' argument.</li>
-# Use a '''ForEach<DataRow>''' activity to iterate over the records fetched from the table.
+<li>Use a '''ForEach<DataRow>''' activity to iterate over the records fetched from the table.</li>
-# A column of the recordset (table) can be accessed by its index.
+<li>A column of the recordset (table) can be accessed by its index.</li>
 =Example=

← Older revision		Revision as of 10:03, 12 February 2015
Line 1:		Line 1:
−	{{UBIK}} uses OLEDB to ~~connecti~~ to Oracle via TNS (Transparent Network Substrate), therefore it is necessary to configure the connection to the server on your local environment prior to connecting to an Oracle database.	+	{{UBIK}} uses OLEDB to connect to Oracle via TNS (Transparent Network Substrate), therefore it is necessary to configure the connection to the server on your local environment prior to connecting to an Oracle database.

	= Instructions =		= Instructions =

← Older revision		Revision as of 10:03, 12 February 2015
Line 35:		Line 35:

	[[Category:OLE]]		[[Category:OLE]]
−	~~[[Category:Workflow]]~~
	[[Category:How-To]]		[[Category:How-To]]