Knowledge Base

Creating a SQL Server Real-Time Data Source

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com
Working with SQL Server

Creating a SQL Server Real-Time Data Source

  • From the main Navigation Menu, select Data Sources>>Realtime Triggers.
  • On the Realtime Triggers page, click the Create Realtime Trigger Button.
  • On the New Realtime Trigger page, click MSSQL Table Real-Time Data Source.
  • Enter a Description for the MSSQL Table Real-Time Data Source.
  • Select a Connection to a MSSQL Connector.
  • Click Validate.
  • Select a table to add a real time trigger to.
  • If you only want to trigger the source on certain columns, mark those in the Restrict Table Columns.
  • Set the Log action as needed.
    • Save Failures: Will log only failed records.
    • Always Save: Will log successes and failures.
    • Save Successes: Will log only successes.
    • None: will not log any records.
  • Click Save. This will save the source with all columns from the table. If you do not need to modify the query the real time source is ready to be used on an integration.
  • If you need to modify the query, click the Edit Query.
  • By default, the chosen table from step 7 will automatically be loaded with all columns selected. Any modification to the query can be done at this time. See query builder use here. Needs to link to article on query builder.
  • Click Save Query.
  • Click Validate.
  • 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