Knowledge Base

Creating an OLEDB Bulk Data Source

How can we help?

Browse Common Categories

Getting Started with

Creating an OLEDB Bulk Data Source

  1. On the left side options column click Data Sources >> Bulk Sources >> Query.
SC Query Source Location

  1. On the Query Data Sources page click Create Bulk Query button.
SC Create Bulk Query Button
  1. On the New Query Data Source page click the OLEDB Query Data Source button.
OLDEB Query Icon
  1. The page to configure the OLEDB Data Source opens.
OLEDB Query Window

  1. Enter a Name for the query.
  2. Connection – Select the connection to be used from the drop-down list.
  3. Click Validate. If the validation is successful, the Edit Query button becomes active.
  4. Click Edit Query – Opens the Query Builder to create a new query or edit an existing query.

  1. After the query has been created click on Next to return to the OLEDB Query Data Source window.
  2. Click the Preview button to preview the source data.
  3. Click Save to save the query source.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2023 SmartConnect|eOneSolutions
Cloud Terms of ServicePrivacy PolicyTerms of ServiceEULA

How can we help?