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.0.0
    1. Rich observability capabilities
    2. Feature added to protect task authors from pushing into Universal Controller unnecessary database data by providing the capability to control the number of lines from the SQL result set that will be available on extension output. Task Authors can use UE_EXTENSION_OUTPUT_MAX_SQL_ROWS environment variable to control the behavior 
    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

    What's New in V2.1.0
    1. Official support for Amazon Redshift Database.
    2. New Choice Field “SQL Source” that gives the opportunity to provide the SQL Script either as a UAC Script or as plain text.
    3. Enhanced security when the Connection Method is “Connection String” by selecting the proper Credential and passing it via the connection string. This can be achieved using the following notation: [credential_name].user and [credential_name].password.
    4. Fix "authenticate with the system user" connectivity when the Connection Method is “Connection String” and the Database Type is “MSSQL”.

    Extension Name: ue-sql-odbc
    Universal Template Name: SQL ODBC
    Version: 2.1.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.