Created on 16 January 2013
icon_unfollowing
Login to follow
sql-map

SQL Map

icon_trusted
Stable version 2.0.1 (Compatible with OutSystems 11)
Other versions available for 10 and Older
Uploaded on 06 December 2021 by 
sql-map

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.
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)
Category
Development tools, Database
Support options
This asset is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from  who created this asset.
Dependencies
SQL Map has no dependencies.
Application Objects
SQL Map has 0 AOs.
Team
Compatible with
Version 11
Database:
All
Asset consumers
No consumers yet.
Weekly downloads 
Related assets