Execute SQL

Note: This is an external action and may execute on servers running outside your data centerCentralized locations used to house servers used by Nintex for remote storage, processing, or distribution of data. Nintex has a number of regional data centers available for Nintex for Office 365. For information about Nintex data centers and where your data center is located, contact your Nintex account or territory manager. region. Before implementing, consider performance and regional concerns where digital boundaries are an issue. For more information, see In-tenant and external actions.

Queries Microsoft SQL Server databases.

Note: The database must be internet-accessible. Only SQL authentication is supported over http using port 1433, as an unsecured connection (username and password are sent as plain text).

What can I do with this workflow action?

You can use this action to create tables, add data to tables, and modify, delete, or retrieve data from connected databases.

Action settings

Do one of the following to open the Action configuration window:

  • Double-click the action.
  • Click on the action and then click Configure.

See Action configuration window for more information.

Field Description
Connection string

Specify the SQL connection string to connect to a remote SQL database.

Example: Data Source=myServerAddress;Initial Catalog=myDataBase;User ID=myUserID;Password=myPassword;

Query

Specify the SQL statement.

A maximum of 200 results is returned. If required, update the query to retrieve the next 200 results.

Note: Column names with spaces (such as a column named "Client Count") are not supported in the query.

Column to retrieve

Specify a column name to retrieve from SQL 'SELECT' query results.

Results count

Specify a number variable to store the total number of results returned.

Retrieved column values

Specify a collection or dictionary variable to store the values of the column to retrieve.

Note: If a column to retrieve is not specified, the first column retrieved from the query will be returned.

Results in XML

Specify a collection or dictionary variable to store the query results in XML format.

For more information about how to use Lookups in configuration fields, see Lookups in action configuration fields.