Jump to: navigation, search

CreateOLESQLScope (Activity)


Revision as of 11:44, 9 January 2015 by JKN (Talk | contribs) (Created page with "{{ActivityInfoBox | title = Create OLE SQL Scope | name = CreateOLESQLScope | image = 220px | imagecaption = CreateOLESQLScope (Expa...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Create OLE SQL Scope
Name CreateOLESQLScope
Purpose Connect to SQL Server via OLE
Category UBIK Data Exchange
Returns True if successful
Version 2.4.1+

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

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 CreateOLETableScopeactivities, 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":

x700px

See also