| Panel | |
|---|---|
|
| Warning | ||
|---|---|---|
| ||
It is replaced by SQL ODBC Task. |
Disclaimer
Your use of this download is governed by Stonebranch’s Terms of Use, which are available at https://www.stonebranch.com/integration-hub/Terms-and-Privacy/Terms-of-Use/
...
Overview
This Universal Task allows users to execute SQL scripts and functions against a MySQL, PostgreSQL, Microsoft SQL Server, Oracle and SAP HANA database.
...
Software Requirements for /wiki/spaces/UC71x/pages/5178050 and /wiki/spaces/UC71x/pages/5180675
...
Universal Template and Universal Task
- Universal Agent needs to be installed with python option (--python yes).
The python ODBC module pyodbc v4.0.30 needs to be installed for MySQL, PostgreSQL and Microsoft SQL Server connections.
The python SAP HANA module hdbcli v2.6.58 needs to be installed for SAP HANA connections.
The python Oracle module cx_oracle 8.0.1needs to be installed for Oracle Database connections.
Software Requirements Universal Agent
- Universal Agent for Linux or Windows Version 7.0.0.0 or later is required.
Software Requirements Universal Controller
Universal Controller 67.90.0.0. or later is required.
Software Requirements for the Application to be Scheduled
...
To use this downloadable Universal Template, you first must perform the following steps:
- This Universal Task requires the /wiki/spaces/UC71x/pages/5178443 Resolvable Credentials feature. Check that the/wiki/spaces/UC71x/pages/5177877 Resolvable Credentials Permitted system property has been set to true.
- Copy or Transfer To import the Universal Template file to a directory that can be accessed by the Universal Controller Tomcat user.
In the Universal Controller UI, select Configuration > Universal Templates to display the current list of /wiki/spaces/UC71x/pages/5178054.
Right-click any column header on the list to display an Action menu.
Select Import from the menu, enter the directory containing the Universal Template file(s) that you want to import, and click OK.
- into your Controller, follow the instructions here.
- When the files have been imported successfully, refresh the Universal Templates list; the Universal Template will appear on the list.
Configure SQL Universal Tasks
...
This document references the following documents:
Name | Location | Description |
|---|---|---|
https://docs.stonebranch.com/confluence/display/UC71x/Universal+Templates | User documentation for creating Universal Templates in the Universal Controller user interface.Universal Tasks | |
https://docs.stonebranch.com/confluence/display/UC71x/Universal + Tasks | User documentation for creating Universal Tasks in the Universal Controller user interface. |
...