+1 (888) 319-3663 | sales@smartconnect.com

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.

Leave a Comment