SQL Map - Overview (O11) | OutSystems

Log in

Give us feedback

Stable version 2.0.1 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded on 06 December 2021 by

4.8

(20 ratings)

sql-map

Details

Do you need to test an advanced query in your favorite SQL tool (e.g. SQL Management Studio), but hate converting entity names to physical table names (or the other way around)? Developers can use this tool to speed up the conversion.

Asset screenshot_0

Asset screenshot_1

Asset screenshot_2

Read more

Feature List

Convert Service Studio queries to "physical SQL" queries.
Convert "physical SQL" queries to Service Studio queries.

Example: converts between

select * from {User}

and

select * from ossys_user

Main Benefits

Speeds up testing queries in a dedicated SQL client.

System Requirements

Platform 9.0.0.2+.
The oldest version requires SortRecordList - download and install it before publishing SQLMap.

Limitations

External tables (referenced via Integration Studio) are not supported.
This is a port of a very old eSpace (AP 3.x). Because referencing system entities was not supported at the time (or most likely I wasn't aware), the code has some workarounds, making it more complex than it should be.

Release notes (2.0.1)

Demo is now on a separate application.
Demo and component’s descriptions updated.
GetESpaces server action now works in environments that have Oracle as the DB provider.

Reviews (0)

Team

MVP

MVP

Staff

MVP

Related assets

Discovery is a visual tool to help analyze, measure and understand how to improve your factory architecture

data-migration-manager-dmm

Data Migration Manager is a robust, cost-efficient, and intuitive data management solution. DMM - Data Migration Manager enables you to reduce costs by saving hundreds of hours that were spent in building custom scripts, allowing you to increase quality and unprecedented flexibility and speed in managing your data. DMM enables data and BPT migration across/into/out of OutSystems environments (onPrem, Hybrid, Cloud, PaaS), databases (mySQL, Oracle, SQLServer) and OS versions (v9 , v10 or v11) using a simple user interface without the need of building custom scripts. It also supports features like data anonymization, data scramble and data deletion, essential to comply with GDPR.

TestFramework is an open-source application that offers simple management and automated execution of OutSystems Unit and API tests. With seamless integration with BDD Framework and Unit Testing Framework , it allows automated regression tests setup and execution. With the recent addition of Ghost Inspector integration, it now also allows the inclusion of automated UI tests in the test suites. TestFramework is provided by Indigo, an OutSystems partner, with ample experience in automated testing strategy and implementation. With the latest update, it’s now possible to analyze, track, and produce reports of your project’s code coverage, load tests from other environments and schedule your test runs! Take a tour!

More from Paulo Ramos

unit-testing-framework

Unit Testing Framework allows you to easily develop and run unit tests for your OutSystems Platform projects. Get the comprehensive user guide from: http://tinyurl.com/utf-manual

Test Automator is a Browser and Unit Regression Testing tool for the OutSystems Platform, versions 7 and up.

1358111337-box-wooden-png

A collection of reusable actions to help us stop reinventing the wheel. Join the team and bring your own top reused actions to the community!