Jump to: navigation, search

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


Line 44: Line 44:
 
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
 
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
  
[[Category:Workflows]] [[Category:Activities]] [[Category:Interfacing]] [[Category:OLE]]
+
[[Category:OLE]]
 +
[[Category:Activities]]

Revision as of 17:29, 2 February 2015

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

The CreateOLESQLScope or CreateOLEOracleScope connects to a SQL Server or Oracle 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 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":

UI Activity CreateOLEDBScope Example.png

See also