Contact

SQL: ODBC Task

USD$ 0.00*

Product number: SB10175
New Free Video
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 format).
  • Rich Observability capabilities

What's New in V3.1.0

  • Added the option to retrieve SQL script to be executed via local path.
  • Resolved issue which would cause the extension to crash when a path containing a '.' was specified in the Output File Path field.

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.

Stonebranch is an SAP partner. Universal Automation Center (UAC) is certified by SAP for SAP S/4HANA and RISE with SAP S/4HANA® Cloud.

SAP Certification Badge


Extension Name: ue-sql-odbc
Universal Template Name: SQL ODBC
Version: 3.1.0
Vendor: Microsoft
Type: Free
Compatibility : UC/UA 7.4 and above
Support: Stonebranch Certified