SQL: ODBC Task
Product information "SQL: ODBC Task"
This Universal Extension provides the capability to integrate with ODBC compliant database, by running single or multiple SQL commands and retrieving the resulting data. While it is designed to work with any ODBC-compliant database, it is thoroughly tested against MySQL, MSSQL Server PostgreSQL, and Oracle databases. As opposed to the native UAC SQL Task, which runs on the Controller, this integration allows the user to run an SQL Task from the Agent.
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 formats).
- Rich Observability capabilities
What's New v 3.2.0
Enhancements
- Added an option to quote only non-null characters.
- Added a Large Text Field option when connecting via a connection string, allowing the use of large text fields instead of regular ones.
- Enabled supplying credential fields from the task’s database credential using annotations such as: {{ database_credentials.[user | password | passphrase | key_location | token] }}
Fixes
- Output file paths and key_location paths are now always normalized at initialization.
Breaking changes
Version 3.0 is compatible from Universal Controller & Universal Agent 7.4 onwards. Dependent Python Libraries (pyodbc) are now bundled within the integration archive and do not have to be installed manually.
| Extension Name: | ue-sql-odbc |
|---|---|
| Universal Template Name: | SQL ODBC |
| Version: | 3.2.0 |
| Vendor: | Microsoft |
| Type: | Free |
| Compatibility : | UC/UA 7.5 and above |
| Support: | Stonebranch Certified |