SQL Utility Connector Reference

The SQL Utility Connector for Saltbox enables SQL query support for Microsoft SQL Server and Polar DB (both MySQL and PostgreSQL).

This connector uses the Remote Agent Web API Service to securely access a SQL database on the host system. Install and configure the service before using this connector.

Actions Reference provides details for actions used to build a workflow.
Workflow Trigger Reference provides details on how to configure advanced settings to fetch the data needed by a workflow.
- Format Settings Reference provides details about how to handle and pre-process trigger data.

Release Notes for SQL Utility Connector

SQL Utility Connector updated - v1.7.0

v1.7.0 - October 28, 2024

SQL Utility Connector version 1.7.0 adds date variable replacement to SQL Utility Connector Message Source.

SQL Utility Connector updated - v1.6.1

v1.6.1 - October 23, 2023

SQL Utility Connector version 1.6.1 fixes an issue in the SQL data source format (used in trigger format settings) when query results have invalid characters such as "end-of-file" character \\u001a (69415).

SQL Utility Connector updated - v1.6.0

v1.6.0 - August 21, 2023

SQL Utility Connector version 1.6.0 adds the option "Convert Dates To UTC" on trigger format settings.

SQL Utility Connector updated - v1.5.0

v1.5.0 - February 6, 2023

SQL Utility Connector version 1.5.0 adds an option to retrieve ODBC query data using POST request (63512).

SQL Utility Connector updated - v1.4.0

v1.4.0 - October 24, 2022

SQL Utility Connector version 1.4.0 adds support for ODBC connections.

SQL Utility Connector updated - v1.3.2

v1.3.2 - September 6, 2022

SQL Utility Connector version 1.3.2 fixes a bug when using single quotes in queries (60444).

SQL Utility Connector updated - v1.3.1

v1.3.1 - April 18, 2022

SQL Utility Connector version 1.3.1 adds default settings to workflow triggers.

SQL Utility Connector updated - v1.3.0

v1.3.0 - January 4, 2022

SQL Utility Connector version 1.3.0 adds a new action to Get Results from a Query.

SQL Utility Connector updated - v1.2.4

v1.2.4 - November 1, 2021

SQL Utility Connector version 1.2.4 adds a new JSON Path filter to workflow triggers.

SQL Utility Connector updated - v1.2.3

v1.2.3 - October 25, 2021

SQL Utility Connector version 1.2.3 fixes bugs in the PolarDB workflow trigger when using WHERE filters.

SQL Utility Connector updated - v1.2.2

v1.2.2 - October 12, 2021

SQL Utility Connector version 1.2.2 fixes a bug in the workflow trigger when attempting to split messages using the option "SQL Connector Converter - with split options".

SQL Utility Connector updated - v1.2.1

v1.2.1 - October 4, 2021

SQL Utility Connector version 1.2.1 is a minor update to the connector name and supporting details to reflect increased support across SQL vendors.

Microsoft SQL Server Connector updated - v1.2.0

v1.2.0 - September 27, 2021

Microsoft SQL Server Connector version 1.2.0 adds support for PolarDB.

Microsoft SQL Server Connector updated - v1.1.0

v1.1.0 - June 14, 2021

Microsoft SQL Server Connector version 1.1.0 adds an action to run stored procedures.

Microsoft SQL Server Connector updated - v1.0.4

v1.0.4 - June 7, 2021

Microsoft SQL Server Connector version 1.0.4 adds target mapping files to all actions, and fixes a known memory issue.

Microsoft SQL Server Connector updated - v1.0.3

v1.0.3 - May 10, 2021

Microsoft SQL Server Connector version 1.0.3 patches broken action and thumbnail icons in Saltbox UI.

Microsoft SQL Server Connector updated - v1.0.2

v1.0.2 - February 17, 2021

Microsoft SQL Server Connector version 1.0.2 allows data to be fetched in xml format in addition to json format.

Microsoft SQL Server Connector updated - v1.0.1

v1.0.1 - October 15, 2020

Microsoft SQL Server Connector version 1.0.1 patches a security issue with its connector config.