Connect to an External SQL Database

By default the query block accesses the SysTrack database. However, you can connect to a different SQL Server database by supplying connection information. The SQL query will then be run against the specified database.

  1. Select the relevant Query block. In the Properties panel, open the Connection String section.
  2. Deselect the Use SysTrack database option.

  1. With the Database tab selected (this is the default), enter a Name (required), and a Description (optional) for the connection.
  2. Enter the Serveron which the database resides.
  3. Enter the Database name.
  4. In the User field, enter the user with access to this database.
  5. Enter a Password for the user.
  6. Optionally, enter any Extended Properties.
  7. If you are using Windows credentials instead of a SQL account for this connection, select the Integrated check box, otherwise leave this box unchecked.
  8. Click the Apply button to save your changes.
  9. To save this connection as a shared connection, click the Share connection button.

The Query Data block will now include an icon showing that it is linked to an external database: