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

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.

Leave a Comment