Relational Population Service (RPS) Security

The RPS Datapump application JadeRpsDataPump, which runs on the RPS node from the schema in which the RPS mapping is defined, connects to the RDBMS database and applies transactions to it, implementing the incremental object replication. To allow the Datapump application to be started without user intervention, it must be able to log on to the SQL Server with a valid account. You can accomplish this by performing one of the following actions.

Run the RPS node under a Windows account that has the required access rights and database permissions.
Configure an SQL Server account in the RPS mapping. (For details, see "Setting Up the RPS Options", in Chapter 15 of the JADE Development Environment User’s Guide.)

The first of these actions is more secure, as it avoids the need to save password information in the RPS mapping meta data.

For details, see "RPS Datapump Application", in Chapter 2 of the JADE Synchronized Database Service (SDS) Administration Guide.