This document highlights some features and usage patterns we hope are useful in the development of your applications.
A modal panel is a pop-up panel that forces the user to interact with it before they can go back to using the rest of the application. You can create Data Links from within your main application to a modal panel as well as between modal panels. Modal panels are a great way of simplifying the user experience by not presenting too much information all at once.
Accessing a large amount of federated data for analysis can be slow, especially where joins and large tables are involved. Often a better solution is to create a local copy of the data at periodic intervals to create a data warehouse of sorts. Although most of our Smart Connectors support automatic caching, sometimes creating an actual copy within the database itself is needed for complex joins or other reasons.
You can accomplish this with a Scheduled Event that runs periodically and refreshes the data (see Tools > Scheduled Events...). The simplest way, if the data isn't too large, is using a commands like the following within a Scheduled Event:
For the very advanced power user, you can use dynamic SQL within a stored procedure using the EXECUTE IMMEDIATE statement. See the EXECUTE IMMEDIATE documentation for details.
One potential use case is to create a stored procedure that is called via the API with dynamic values passed into the procedure as a JSON parameter.