CreateOLEOracleScope (Activity)
Revision as of 12:05, 23 February 2015 by KNO (Talk | contribs) (Created page with "{{ActivityInfoBox | title = Create OLE Oracle Scope | name = CreateOLEOracleScope | image = 220px | imagecaption = CreateOLEOracl...")
| Create OLE Oracle Scope | |
|---|---|
| Name | CreateOLEOracleScope |
| Purpose | Connect to an Oracle database via OLE |
| Category | UBIK Data Exchange |
| Returns | True if successful |
| Version | 2.4.1+ |
The CreateOLEOracleScope connects to an 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.
[edit]
Example
The CreateOLESQLScope activity, as used in the larger example "Read MetaClass names from UBIK database":
