The CreateOLESQLScope connects to a SQL Server database and provides access to its tables and views.
= Description =
{{ActivityInfoBox
| title = Create OLE SQL/Oracle Scope| name = CreateOLESQLScope/CreateOLEOracleScope
| image = [[File:UI_Activity_CreateOLESQLScope.png|220px]]
| imagecaption = CreateOLESQLScope (Expanded)
}}
The CreateOLESQLScope or CreateOLEOracleScope connects to a SQL Server or Oracle database and provides access to its tables and views. ===Arguments===
{| class="wikitable sortable" | width = "50%"
|-
|}
===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 [[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":
[[File:UI_Activity_CreateOLEDBScope_Example.png|x700px|border|CreateOLESQLScope]] <headertabs />
==See also==
* [[Workflow Designer]]
* [[Activity:CreateOLETableScope (Activity)]]
* [[HowTo:Connect_To_Oracle_With_A_Workflow]]
[[Category:OLE]]
[[Category:Activities]]