Update a SQL Server Destination

About this task

To update a destination:

Procedure

  1. On the Configurations page, expand the app and click Configure under the Destinations heading.
  2. Open the destination that you want to edit and update the settings you want to change.
  3. Choose a new SQL Server Connection from the dropdown list.
  4. Enter a name for the destination. Since you can create multiple destinations for the same connection, it's important that the destination name is descriptive.
  5. Enter an INSERT INTO SQL statement into the Insert Script box to specify how the data from the app is added to the database.
    Important: If you do not add a INSERT INTO SQL statement, no app data will be exported to the destination.
    Tip: You can add macros to the script so the data changes dynamically. Click Macros in the top right corner of the field to see available macros.
  6. 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 a UPDATE SQL statement, modified records are not sent to the destination.
    Tip: You can add macros to the script so the data changes dynamically. Click Macros in the top right corner of the field to see available macros.
  7. Click Test Destination to confirm that the destination is active.
  8. Click Save to save your settings.

Results

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