SQL Map
Stable Version 1.0.2
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
SQL Map has no consumers.
Weekly Downloads 
Related Components
Discovery
Architecture Team
A tool to discover and measure your architecture and understand how to improve
3012
OutSystems Now
OutSystems R&D
OutSystems Now brings your OutSystems experience to any device.
7183
OnTrack
Labs
The OnTrack open source application template offers powerful, yet simple, project tracking and collaboration, to support fast continuous delivery of your applications. Integration with OutSystems App Feedback allows end-to-end follow-up by the project teams on new requests and issues reported by your users. Pick this pre-built app and customize it at will to fit your specific delivery process. Watch a quick overview video of OnTrack .
1022
More from Paulo Ramos
Unit Testing Framework
Andrew Burgess
Unit Testing Framework allows you to easily develop and run unit tests for your OutSystems Platform projects. Get the comprehensive user guide from: http://tinyurl.com/utf-manual
1268
Essentials
Essentials
A collection of reusable actions to help us stop reinventing the wheel.  Join the team and bring your own top reused actions to the community!
1659
Test Automator
Test Automator Team
Test Automator is a Browser and Unit Regression Testing tool for the OutSystems Platform, versions 7 and up.
792