Mapping Your JADE Database to a Relational Database
The Relational Population Service (RPS) provides automatic replication of objects from a production JADE database to one or more relational databases when running an RPS node.
The Relational Population Service wizard provides facilities that enable you to map classes and properties to the required relational tables and columns.
All mapping meta data becomes part of the system specification in the JADE database, and can be extracted, loaded, versioned, and so on.
The supported RPS relational target databases are Microsoft SQL Server 2008 and higher.
An RPS system consists of:
-
An RPS mapping defined in the JADE production database, which maps classes and attributes of a JADE schema to relation database tables and columns.
-
An RPS node (or multiple RPS nodes), which runs as a relational SDS database and executes the Datapump application to pump the JADE data to the Relational Database Management System (RDBMS) target.
-
An RDBMS target database for each RPS node, which contains the tables and columns defined in the RPS mapping.
-
The RPS Manager utility, which enables you to create the RDBMS tables and columns from the RPS mapping, load the data instances from the JADE production database, and control the execution of the Datapump application.
For details about mapping your JADE database to a relational database, see Chapter 15, "
For considerations when using RPS, see Chapter 2, "