SQL: ODBC Task
Product information "SQL: ODBC Task"
Key Features
- Flexibility in database connection definition supporting DSN, FILE DNS and Connection String.
- Rich metadata information.
- Capability to store SQL results in files (CSV or JSON format).
- Rich Observability capabilities
What's New in V2.2.0
Provide the capability to enable or disable the auto-commit mechanism for MS SQL Server databases.
Breaking changes
- Compatibility of this integration has been changed. It is applicable for Universal Controller and Universal Agent with version >=7.2
- "Status Description" text information has been updated. Tasks or workflows evaluating the "Status Description" of the task Instance, either programmatically or within UAC, might be affected by it. In that case, they need to conform to the new "Status Description" Text
- In this version, by default, the returned datasets displayed on the extension output are truncated to the first 100 rows. If more than 100 rows need to be pushed into the extension output, the environment variable UE_EXTENSION_OUTPUT_MAX_SQL_ROWS needs to be set appropriately on the task definition
- Extension Invocation Fields > Credential fields are displayed as an object for better readability
Extension Name: | ue-sql-odbc |
---|---|
Universal Template Name: | SQL ODBC |
Version: | 2.2.0 |
Vendor: | Microsoft |
Type: | Free |
Compatibility : | UC/UA 7.2 and above |
Support: | Stonebranch Certified |
Please visit this link to find key features, prerequisites, installation instructions, configuration instructions, and examples of how to use this integration.