The RPM to SQL enhancement imports data from RPM processes into SQL tables.
Data update is incremental. Every integration iteration checks forms in configured RPM processes and/or basic entities for changes, comparing based on the "Modified" property of RPM objects and the "Modified" column of SQL records.
Matching of RPM object to SQL records is based on RPM IDs (FormID, CustomerID, AgencyID, etc) and ID SQL table columns. After that changed RPM data is pushed into the relevant SQL tables.
The application is deployed in the customer's intranet and runs on a regular basis, using a system scheduler (every 15 minutes, for example).
Can be used in integrations between RPM and any SQL storage-based system.