Relational Population Service (RPS) Restrictions

The JADE RPS implementation excludes the following functionality.

• User JADE applications (including read-only applications) may not execute properly on Mapped Extent 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.