The OLE DB data connector is an object that is used to get database data by means of OLE DB drivers installed in the operating system.
OLE DB (Object Linking and Embedding, Database) is a collection of interfaces implemented using the Component Object Model that enable the user to access data stored in various data providers or data warehouses in an uniform manner.
After adding the connector to the ETL task workspace, set basic properties and import options. The connector output can also be edited and data filtering options can be set.
In basic properties object name, identifier and comment are set.
The Import Options page enables the user to specify parameters for connection to the source and query, according to which data is retrieved from the source:
Enter data provider connection string manually or in the special dialog box. To activate dialog box, click the 
button.
Enter the query text, in accordance with which the data is selected, in the Query input box.
The Advanced Settings button enables the user to determine advanced settings used on data identification.
The View Data button shows data selected by a query.
NOTE. Only the first hundred of the provider lines will be displayed during the data preview.
To set a list of fields and output link, use the Output Edit page.
The following settings are available on the page:
The Set Up Data Filtering of the Source page is used to specify the condition, by which imported data is selected:
NOTE. The page is not displayed for copying data object if a standard cube is selected as a data provider.
To apply filtering condition, click the button. The following dialog box opens expression editor. All provider fields can be used to create an expression. The data that satisfies the specified condition is imported.
See also:
Identifier
and 
buttons.