Jump to: navigation, search

Difference between revisions of "Activity:CreateOLESQLScope (Activity)"


(See also)
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 +
The CreateOLESQLScope connects to a SQL Server database and provides access to its tables and views.
 +
 +
= Description =
 
{{ActivityInfoBox
 
{{ActivityInfoBox
| title = Create OLE SQL/Oracle Scope
+
| title = Create OLE SQL Scope
| name = CreateOLESQLScope/CreateOLEOracleScope
+
| name = CreateOLESQLScope
 
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
 
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
 
| imagecaption = CreateOLESQLScope (Expanded)
 
| imagecaption = CreateOLESQLScope (Expanded)
Line 10: Line 13:
 
}}
 
}}
  
The CreateOLESQLScope or CreateOLEOracleScope connects to a SQL Server or Oracle database and provides access to its tables and views.
+
===Arguments===
 
+
==Arguments==
+
 
+
 
{| class="wikitable sortable" | width = "50%"
 
{| 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.
 
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==
+
=Example=
 
The CreateOLESQLScope activity, as used in the larger example "Read MetaClass names from UBIK database":
 
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|x700px|border|CreateOLESQLScope]]
 +
 
 +
<headertabs />
  
 
==See also==
 
==See also==
Line 45: Line 47:
  
 
[[Category:OLE]]
 
[[Category:OLE]]
[[Category:Activities]]
 

Latest revision as of 15:47, 23 February 2015

The CreateOLESQLScope connects to a SQL Server database and provides access to its tables and views.

[edit]

Description

Create OLE SQL Scope
Name CreateOLESQLScope
Purpose Connect to database via OLE
Category UBIK Data Exchange
Returns True if successful
Version 2.4.1+

Arguments

Argument Type Direction Purpose
DataSource String In The unique name of the database to connect to
InitialCatalog String In The database instance to connect to
UserName String In The user name to connect with
Password String In The corresponding password for the user
Tables List<OLETableDescriptor> Out A list of all found tables in the database
Result Boolean 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 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":

CreateOLESQLScope

See also