Add a SQL Server Connection

About this task

If your Microsoft SQL Server database does not have public APIs, then it must be on the same computer or network as the computer where SOTI Snap Link is installed so that SOTI Snap Link and the database can communicate. Databases with public APIs can be anywhere, though you must share those public credentials with SOTI Snap Link.

To add a SQL Server connection to SOTI Snap Link:

Procedure

  1. On the Configurations page, select Manage Connections.
  2. Click Add Connection.
  3. Choose SQL Server as the connection type.
  4. Fill in the connection details for the SQL Server database.
    Connection Name Enter a name for the connection. It should be unique within this SOTI Snap Link console.
    Server Name Enter the name of the server where your database resides.
    Note: Microsoft SQL Server databases without public APIs must be on the same computer or network as SOTI Snap Link.
    Database Name Enter the name of the database where you want to export the app data.
    Username Enter the username.

    Only SQL server authentication is supported. The account must have read, write, and update permissions for the database.
    Password Enter the corresponding password.
  5. Click Test Connection to verify that connection details are correct and SOTI Snap Link can connect to the specified SQL server.
  6. Select Save to save the connection.

What to do next

For apps whose data you want sent to this connection, create a destination that references this connection.