Last modified on 23 February 2015, at 15:47

CreateOLESQLScope (Activity)

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