Add a SQL Server Destination
Before you begin
Set up a SQL Server connection.
About this task
Destinations are where the data extracted from an app form is sent. You can send data from one app to multiple destinations. Destinations are configured by data export rules. That is, when you created the data export rule in the SOTI Snap console, only data as filtered by that rule is available to be sent to the destination.
To set up a destination:
Procedure
- On the Configurations page, expand the app and click Configure under the Destinations heading.
- Click Add Destination
- Choose SQL Server as the destination type.
- Choose a SQL Server Connection from the dropdown list.
- 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.
-
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 aINSERT 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. -
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 aUPDATE
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. - Click Test Destination to confirm that the destination is active.
- Click Save to save your settings.