Abstract: Various embodiments of systems and methods to validate relationships between entities are described herein. In one aspect, upon receiving a selection of an object associated with a source entity, a list of associations corresponding to the source entity is provided, where each association defining a related target entity. Further, upon receiving a selection of at least one association from the list of associations entity relationship data corresponding to the selected object is retrieved from destination entities defined by the at least one selected association. And, the retrieved entity relationship data is rendered on a computer generated user interface.

Abstract: Various embodiments of systems and methods for validating Structured Query Language (SQL) queries in a software programming language report during application development are described herein. The method involves receiving a selection of a specific SQL query in the report and automatically invoking a data preview editor interface. The selected query is rendered on the interface for execution. In an aspect, the selected query is parsed and a source part and a result part are extracted. Based on the extracted source part and result part, a data type definition and data declaration are automatically determined for the accessed data. Further, a dynamic subroutine is generated with the determined data type definition, data declaration, and the selected query and executed. A preview of the result of executing the dynamic subroutine is rendered in the data preview editor for validating the query.

Abstract: Disclosed are methods, systems and products, including a computer implemented method that includes obtaining by at least one of a plurality of entities at least one master template available to the plurality of entities to generate documents from the at least one master template. The at least one master template includes at least one template area, with each of the at least one template area being associated with a respective data type. The method also includes generating a document by the at least one of the plurality of entities based, at least in part, on the at least one master template using entity-specific data associated with the at least one of the plurality of entities for the data type associated with the at least one template area.