Relational Population Service (RPS)
The Relational Population Service (RPS) provides automatic replication of objects from a primary JADE database to one or more relational databases.
RPS enables JADE systems to interoperate with relational databases for reporting, Business Intelligence (BI), Extract, Transform, Load (ETL), and data warehousing purposes.
For details about the Microsoft SQL Server ODBC drivers that must be used, see "
RPS enables JADE systems to automatically replicate data into external relational databases in near real-time. Developers can specify the classes, objects, and properties that are to be replicated to the required relational database or databases. This allows an entire JADE database to be replicated, or just the data that is required for external purposes.
RPS is built on Synchronized Database Service (SDS) technology and uses the same mechanisms as SDS for propagating updates to secondary databases. Updates recorded in database journals written by the primary database are mirrored to attached secondary databases and applied.
RPS can populate an entirely independent relational database, or tables within an existing relational database where that database can be updated from multiple sources (that is, via JADE’s RPS and also from non-JADE systems). In either case, the tables updated by RPS are defined and controlled by JADE.
Additionally, an RPS node operating in full replica mode can also be used for disaster recovery, as it can acquire the primary database role in a negotiated or hostile takeover.
This white paper walks you through the steps required to set up an RPS environment. It uses JADE’s Erewhon Investments demonstration application and Microsoft SQL Server Express (freely downloadable) for the relational database.
You need a license for the primary database node and a license for the RPS node. If you do not have these, send an email to jadelicensing@jadeworld.com for consideration of licenses for evaluation purposes.
JADE licenses are not transferred automatically between databases in an SDE. It is your responsibility to apply new licenses to any existing databases in an SDE. In addition, to ensure proper operation, you must apply the primary license to every secondary.
For details about future RPS enhancements, refer to the JADE Roadmap at:
https://www.jadeworld.com/jade-platform/developer-centre/roadmap
You can download other JADE documentation referred to in this white paper from:
https://www.jadeworld.com/jade-platform/developer-centre/learn/documentation
