Stable version 2.0.1 (Compatible with OutSystems 11)

Other versions available for 10 and Older

Uploaded

on 06 December 2021

4.8

(20 ratings)

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.

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