Knowledge Base

Creating a SQL Server Bulk Data Source

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com
Working with SQL Server

Creating a SQL Server Bulk Data Source

  1. From the main Navigation Menu, select Data Sources>>Bulk Sources>>Query.
  2. On the Query Data Sources page, click the Create Bulk Query button.
  3. On the New Query Data Source page, Select MSSQL Query Data Source.
  4. Enter a MSSQL Query Data Source a Name.
  5. Select a Connection to a MSSQL Connector.
  6. Click Validate.
  7. Click Edit Query to launch the query builder.
  8. Add Tables/Views to be used for the bulk source. See query builder use here. Needs to link to article on query builder.
  9. Click Save Query.
  10. Click Validate.
  11. If you want to preview the source data, click Preview.
  12. Click Save.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
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.

© 2021 SmartConnect|eOneSolutions
Privacy PolicyTerms of ServiceEULA

How can we help?

clear