The JADE RPS implementation excludes the following functionality.
User JADE applications (including read-only applications) may not execute properly on Mapped Extent or Working Set nodes, as the required data many not be present.
Mapping data values stored in primitive arrays is not supported.
Mapping methods for non-virtual properties are not executed when extracting property values from a JADE object for replication into relational columns.
Modifying the SQL database being replicated from RPS in order to optimize queries is not recommended.
This is commonly handled in business intelligence solutions by replicating into a staging database. An Extract Transform Load (ETL) process is then run to load the staging data into a database that is optimized for querying. The staging database is typically a straight replica of the production Online Transaction Processing (OLTP) database and as such, is not generally suitable for Online Analytical Processing (OLAP) purposes.