SQL: Execute Scripts and Functions
Product information "SQL: Execute Scripts and Functions"
This integration allows users to execute SQL scripts and functions against a MySQL, PostgreSQL, Microsoft SQL Server, Oracle, and SAP HANA database. It uses an agentless connection via ODBC towards SQL Server, MySQL, and PostgreSQL, and the Oracle basic instant client to connect to an Oracle database.
Key Features:
- Supports execution of SQL scripts for Oracle, MySQL, PostgreSQL, Microsoft SQL Server, and SAP HANA:
- For SQL Server, MySQL, and PostgreSQL: all connections are agentless via ODBC.
- For SQL Server: Windows Authentication and SQL Server Authentication is supported.
- For SAP HANA: database connections are performed agentless using the SAP HANA client for Python.
- For Oracle: the execution of SQL scripts and Oracle PLSQL blocks are supported. Oracle connections are performed agentless using the Oracle basic instant client.
- For SQL Server, MySQL, and PostgreSQL: all connections are agentless via ODBC.
- Supports Universal Agent for both Linux/Unix and Windows.
- Select different log-levels, e.g., info and debug.
- Decide if the SQL-output is provided in the standard out or not.
- All passwords are encrypted using Stonebranch Universal Controller credentials.
| Product Component: | Universal Agent, Universal Controller |
|---|---|
| Vendor: | Microsoft |
| Type: | Free |
| Compatibility : | UC/UA 6.9 and above |
| Support: | Supported |
Please visit this link to find key features, prerequisites, installation instructions, configuration instructions, and examples of how to use this integration.
We are an SAP silver partner. Our product has certified integration with SAP S/4HANA.
