SQL Map

Stable Version 1.1.0 (O11)
Also available for 9, 6
Published on 18 Oct (4 weeks ago) by 
Created on 16 January 2013
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+.
  • 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 (1.1.0)
  • Upgraded to OS11
  • Replaced SortRecordList dependency to use the built-in ListSort action
Reviews (0)
Category
Developer Tools
Support Options
This component is not supported by OutSystems. You may use the discussion forums to leave suggestions or obtain best-effort support from the community, including from Paulo Ramos who created this component.
Dependencies
SQL Map has no dependencies.
Requirements
Platform:
11.0.0.200
Database:
All
Stack:
.NET
Component Consumers
No consumers yet.
Weekly Downloads