SQL Map

Stable Version 1.0.2 (O9)
Also available for 6
Published on 20 October 2014 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.0.2)
Upgraded to P9 as an application pack.
Reviews (0)
Category
Developer Tools
Tags
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
See all 1 dependencies
Requirements
Platform:
9.0.0.1
Database:
All
Stack:
All
Component Consumers
No consumers yet.
Weekly Downloads