SQL Map

Stable version 2.0.0 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Published on 9 Aug 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.
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.
What’s new (2.0.0)
  • Conversion to Reactive
  • Issue: Brackets in Oracle are not supported
Reviews (0)
Related assets
More from Paulo Ramos