Versions Compared

Old Version 1

changes.mady.by.user Former user

Saved on

compared with

New Version 2

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Software Requirements for the Application to be Scheduled

The Universal Task has been tested for the following databases, Versions and Connector. Please make sure that the connector is installed for your database.

In Universal Controller

Administration → Universal Templates → SQL → Fields → odbc_drivername → New - button

Image Removed

Key Features

The solution supports the following file transfer scenarios:

  • The Universal Task supports execution of SQL scripts for Oracle, MySQL, PostgreSQL, Microsoft SQL Server and SAP HANA.

  • For Oracle the execution of SQL scripts and oracle PLSQL blocks are supported.

  • All connections are agentless via ODBC for SQLSERVER, MySQL and PostgreSQL.

  • Oracle connections are performed agentless using the oracle basic instant client.

  • SAP Hana Database connections are performed agentless using the SAP HANA client for Python.

  • The Universal Task supports both Universal Agent for Linux/Unix and Windows.

  • You can select different log-levels e.g. Info and debug.

  • You can decide whether or not the SQL-output is provided in the standard out.

  • All Passwords are encrypted using Controller Credentials.

  • For SQLSERVER Windows Authentication and SQLSERVER Authentication is supported.

...

  • Microsoft SQL Server Installed with Integration Services Catalog (SSISDB).

  • Deploy PYMSSQL python package to the universal agent where SSIS Task would be executed.

  • MS SQL Server Host name or IP address and the Integration services credentials.

Key Features

  • Dynamic Choice Fields to select the SSIS Folder/Project/Package/Environment Reference ID.

  • Launch SSIS Package execution.

  • Monitor SSIS Package execution.

  • Fetch SSIS Package execution logs.

  • SSIS Execution ID and Execution status captured for every execution in the Task Instance.

  • Connection to MS SQL Server is done via the Python PYMSSQL module.

  • Supports Windows and Linux Universal Agents in order to connect to the MSSQL server.

Import the SSIS Universal Extension Task Template

To use this downloadable Universal Template, you first must perform the following steps:

  1. This Universal Task requires the /wiki/spaces/UC71x/pages/5178443 feature. Check that the/wiki/spaces/UC71x/pages/5177877 Resolvable Credentials Permitted system property has been set to true.

  2. Copy or Transfer the Universal Template file to a directory that can be accessed by the Universal Controller Tomcat user.

  3. In the Universal Controller UI, select Configuration > Universal Templates to display the current list of /wiki/spaces/UC71x/pages/5178054 Universal Templates.

  4. Right-click any column header on the list to display an Action menu.

  5. Select Import from the menu, enter the directory containing the Universal Template file(s) that you want to import, and click OK.

...