SQL: ODBC Task

USD$ 0.00*

Product number: SB10175
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 V2.2.0
    Provide the capability to enable or disable the auto-commit mechanism for MS SQL Server databases.

    Breaking changes
    1. Compatibility of this integration has been changed. It is applicable for Universal Controller and Universal Agent with version >=7.2 
    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 
    3. 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 
    4.  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.