Activity:CreateOLEOracleScope (Activity) - Revision history

KNO at 15:45, 23 February 2015

2015-02-23T15:45:42Z

KNO at 12:27, 23 February 2015

2015-02-23T12:27:20Z

KNO at 12:27, 23 February 2015

2015-02-23T12:27:01Z

KNO: Created page with "{{ActivityInfoBox | title = Create OLE Oracle Scope | name = CreateOLEOracleScope | image = 220px | imagecaption = CreateOLEOracl..."

2015-02-23T12:05:06Z

Created page with "{{ActivityInfoBox | title = Create OLE Oracle Scope | name = CreateOLEOracleScope | image = 220px | imagecaption = CreateOLEOracl..."

New page

{{ActivityInfoBox
| title = Create OLE Oracle Scope
| name = CreateOLEOracleScope
| image = [[File:UI_Activity_CreateOLEOracleScope.png|220px]]
| imagecaption = CreateOLEOracleScope (Expanded)
| purpose = Connect to an Oracle database via OLE
| category = UBIK Data Exchange
| returns = True if successful
| version = 2.4.1+
}}

The CreateOLEOracleScope connects to an Oracle database and provides access to its tables and views.

==Arguments==

{| class="wikitable sortable" | width = "50%"
|-
! Argument!! Type !! Direction !! Purpose
|- align="left"
| DataSource|| {{String_MSDN}}|| In || The unique name of the database to connect to
|- align="left"
| InitialCatalog|| {{String_MSDN}}|| In || The database instance to connect to
|- align="left"
| UserName|| {{String_MSDN}}|| In || The user name to connect with
|- align="left"
| Password|| {{String_MSDN}}|| In || The corresponding password for the user
|- align="left"
| Tables|| List<OLETableDescriptor>|| Out || A list of all found tables in the database
|- align="left"
| Result|| {{Boolean_MSDN}}|| Out || True if successful, false if failed
|}

==Usage==
This activity is used to start the communication with an OLE compliant data source. It is a nestable activity, which means it can host any amount of sub-activities that will be processed sequentially. The hosted activities are typically [[Activity:CreateOLETableScope (Activity)|CreateOLETableScope]] activities, either as direct children but also wrapped within looping activities like ForEach or While.

=Example=
The CreateOLESQLScope activity, as used in the larger example "Read MetaClass names from UBIK database":

[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]

==See also==
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]

[[Category:OLE]]
[[Category:Activities]]

@@ Line 37: / Line 37: @@
 The CreateOLESQLScope activity, as used in the larger example "Read MetaClass names from UBIK database":
-[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px]]
+[[File:UI_Activity_CreateOLEDBScope_Example.png|border|x700px|CreateOLEOracleScope]]
 <headertabs />

← Older revision		Revision as of 12:27, 23 February 2015
Line 38:		Line 38:

	[[File:UI_Activity_CreateOLEDBScope_Example.png\|x700px]]		[[File:UI_Activity_CreateOLEDBScope_Example.png\|x700px]]
		+
		+	<headertabs />

	==See also==		==See also==

@@ Line 1: / Line 1: @@
 {{ActivityInfoBox
 | title = Create OLE Oracle Scope
@@ Line 10: / Line 13: @@
 }}
-The CreateOLEOracleScope connects to an Oracle database and provides access to its tables and views.
+===Arguments===
-−
 ==Arguments==
-−
 {| class="wikitable sortable" | width = "50%"
 |-
@@ Line 31: / Line 31: @@
 |}
-==Usage==
+===Usage===
 This activity is used to start the communication with an OLE compliant data source. It is a nestable activity, which means it can host any amount of sub-activities that will be processed sequentially. The hosted activities are typically [[Activity:CreateOLETableScope (Activity)|CreateOLETableScope]] activities, either as direct children but also wrapped within looping activities like ForEach or While.
@@ Line 45: / Line 45: @@
 [[Category:OLE]]