SQL: Execute Scripts and Functions

USD$ 0.00*

Product number: SB10106
Free Video
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.
  • 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.

SAP Certification Badge