Knowledge Base

Setting up an Integration to SQL Server

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com
Working with SQL Server

Setting up an Integration to SQL Server

  • On the Target tab of an Integration Process, choose Microsoft Sql Server for the Target.

  • Choose a SQL Server connection for the Destination. The database for that connection will automatically be populated.
  • Choose either a Table destination or a Procedure destination for the Type.
  • Select the object(s) from the Select dropdown to use in your integration.
    • You can highlight an object and use the arrows to move an object up or down in the list. This will change the order of how the objects are processed, start with the top first.
    • After fields have been mapped, you can delete the mapping by highlighting a line and click the trash icon.
  • Move over to the Integration tab to begin mapping source fields to your target SQL objects.
  • Choose an object to map using the Target Lines dropdown.
  • On the Source Grouping tab mark Group By for fields as a way of grouping data source records to obtain unique combinations.
  • On the Target Integration Tab select the source field in the Source name field that will be matched to the Target Name field.
  • If the integration is intended to update records that are already in the SQL table, mark the Update Existing checkbox.
  • If the integration is intended to remove records that are in the destination SQL table, mark the For Delete checkbox.
  • Update Blank Data not available for this destination.
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