Overview

Extension to execute SQL commands (INSERT, UPDATE, DELETE) and queries with JSON return, directly on external databases mapped in Service Center's Database Connections — without requiring the SQL conversion normally done via OutSystems' Advanced SQL.

Key features

- Execute INSERT, UPDATE and DELETE on any external database configured in Service Center

- Query data and retrieve results in JSON format

- Works with any Database Connection (SQL Server, Oracle, MySQL, PostgreSQL, iDB2)

- No Advanced SQL conversion required — simplifies integration with external data sources

Requirements

OutSystems Platform 11 (O11). A Database Connection configured in Service Center pointing to the external database.

Source code & documentation:

https://github.com/edsoncms/O11_ExternalDatabaseExec