Tips and tricks: Database extension

18.05.2019

I am sure you have also met the situation when the application that you use does not support certain functionality or meeting the desired state would be labour or finance demanding or would lead to a forced use of functionality. If you contact software vendor and they recognize your requirements, you can find a solution in one of future versions. Nevertheless, what should we do if the vendor does not respond, is not willing to adapt the functionality or you need the solution immediately?

ObjectGears allows you to solve above cases by database extension. You can create a view or a stored procedure directly in the database. The view or stored procedure will return data that you can process in ObjectGears script. If you sometimes come across a situation when script objects seem not being able to solve the issue in an elegant way, let us know for sure via customer portal or contact form. We will either advise how to solve the issue including an example, promise a solution in the next version or we will suggest at least temporary solution consisting in database extension. Instead of scripting, database SELECT can be created and used in OG query which you can filter, sort and further use wherever you need.

Check also an example.

Figure: Database level integration can in some cases very well add standard integration by means of web services or URL calls.