Difference between revisions of "Activity:CreateOLESQLScope (Activity)"
m (moved CreateOLESQLScope (Activity) to CreateOLEDBScope (Activity)) |
|||
| (13 intermediate revisions by 3 users 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 Scope | | title = Create OLE SQL Scope | ||
| Line 4: | Line 7: | ||
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]] | | image = [[File:UI_Activity_CreateOLESQLScope.png|220px]] | ||
| imagecaption = CreateOLESQLScope (Expanded) | | imagecaption = CreateOLESQLScope (Expanded) | ||
| − | | purpose = Connect to | + | | purpose = Connect to database via OLE |
| category = UBIK Data Exchange | | category = UBIK Data Exchange | ||
| returns = True if successful | | returns = True if successful | ||
| Line 10: | Line 13: | ||
}} | }} | ||
| − | + | ===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 [[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= | |
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== | ||
* [[Workflow Designer]] | * [[Workflow Designer]] | ||
| − | * [[CreateOLETableScope (Activity)]] | + | * [[Activity:CreateOLETableScope (Activity)]] |
| + | * [[HowTo:Connect_To_Oracle_With_A_Workflow]] | ||
| − | + | [[Category:OLE]] | |
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":
