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, Oracle, SAP HANA, and Amazon Redshift databases.
As opposed to the native UAC SQL Task, which runs on the Controller, this integration allows the user to run an SQL ODBC 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 format).
- Rich Observability capabilities
What's New in V3.0.1
- Refined database message handling
- Resolved issue which would occasionally cause values of consecutively published events to be incorrectly mapped
Stonebranch is an SAP partner. Universal Automation Center (UAC) is certified by SAP for SAP S/4HANA and RISE with SAP S/4HANA® Cloud.
| Extension Name: | ue-sql-odbc |
|---|---|
| Universal Template Name: | SQL ODBC |
| Version: | 3.0.1 |
| Vendor: | Microsoft |
| Type: | Free |
| Compatibility : | UC/UA 7.4 and above |
| Support: | Stonebranch Certified |