Knowledge Base

Creating a SQL Server Real-Time Data Source

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com

Creating a SQL Server Real-Time Data Source

  • From the main Navigation Menu, select Data Sources>>Realtime Triggers.
    SC Realtime trigger location
  • On the Realtime Triggers page, click the Create Realtime Trigger Button.
  • On the New Realtime Trigger page, click MSSQL Table Real-Time Data Source.
  • The page to configure the MSSQL Realtime Data Source opens.

Real-time data source window

  • Enter a Description for the MSSQL Table Real-Time Data Source.
  • Connection – Select the MSSQL connection to be used from the dropdown list.
  • Server Details – Click the Server Details button to show the details of the SQL Server.
  • Click Validate.
  • Table – Select a table to add a real time trigger to.
  • Restrict Table Columns – If you only want to trigger the source on certain columns, mark those here.
  • Log Action – 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.

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

How can we help?

clear