Adding/Updating a SQL Server Destination

Before you begin

Set up a SQL Server connection.

About this task

Destinations are where you send the data extracted from an app form. You can send data from one app to many destinations. Data export rules configure destinations. That is, when you created the data export rule in the SOTI Snap console, the destination receives only data as filtered by that rule is available.

To set up or update a destination:

Procedure

  1. On the Configurations page, expand the app and select Configure under the Destinations heading.
  2. Do one of the following:
    Task Procedure
    Creating a new SQL destination
    1. Select Add Destination
    2. Choose SQL Server as the destination type.
    3. Choose a SQL Server Connection from the dropdown list.
    Updating an existing SQL destination
    1. Open the destination that you want to edit and update the settings you want to change.
    2. Choose a new SQL Server Connection from the dropdown list.
  3. Enter a name for the destination. Since you can create many destinations for the same connection, it is important that the destination name is descriptive.
  4. Enter an INSERT INTO SQL statement into the Insert Script box to specify how to add the data from the app to the database.
    Important: If you do not add an INSERT INTO SQL statement, the destination does not receive any exported app data.
    Tip: You can add macros to the script so the data changes dynamically. Select Macros in the top-right corner of the field to see available macros.
  5. Enter an UPDATE SQL statement into the Update Script field. This script will update existing records in the destination if their data changes.
    If you do not add an UPDATE SQL statement, modified records are not sent to the destination.
    Tip: You can add macros to the script so the data changes dynamically. Select Macros in the top-right corner of the field to see available macros.
  6. Select Save to save your settings.

Results

SOTI Snap exports data from the app to the specified destination according to the settings you choose both here and in the SOTI Snap data export rule.