SQL Management Server like tool 
220
Views
1
Comments
New
Database

There is the SQL sandbox forge component that allows you to query the underlying database.  This tool is fairly limited as if you have a large query or result set it times out.  It works best for a small data set and simple query.   

There are times when the business users would like to get a specific data extract for reporting or to be able to design  / view a report and we have to create a large query to export / extract the records.  This can be quite complicated due to  multiple joins or with a large data set (e.g. 150,000 rows).   This would be one-off type data access. 

Another use case if we need to do an ad-hoc data update on a large set of records such as if there is a re-organization and there are now new departments / regions where a SQL query would be the quickest and most efficient way to update many records   ( e.g. an update query ) since this won't need to be done multiple times it would be easier to run a SQL script vs using a one time data update module or timer to do the mass update. 

A tool like this is also quite helpful to find data corruption or orphan records in the database.   There are times where due to code upgrades the only system with bad data is production so to be able to easily query and see the data would be great. 

OutSystems should provide a tool like SQL management studio that allows us an IT user to create queries directly against the OutSystems database across all applications on the forge.   

There should be security for a read user as well as read / write users.   

Ideally we could easily build a query by selecting the application \modules and the tables.  

Should be able to run a fairly large query  ( for example SQL sandbox has a time out of 2 minutes) 

Have various options to export large data sets ( e.g.  XLS, CSV, XML ) 



Hey Elmar,
Thanks for the idea provided. Will surely try this SQL sandbox forge component and let you know about the use case and performance.