A data dump is an export of some or all of your data from your RPM subscription. The data dump is intended as a one-time data handoff. Our standard rate for Professional Services to process the data dump file may apply.
When you submit a request for a data dump, if you are not the System Manager of the subscription, we will require the consent of the System Manager before we can begin the process. Once we receive the proper approval, we will then proceed with the task, generate the file, and notify you when the file is ready to be received.
Your data will be stored as a 7z zip file. 7-Zip is the free tool that we use to zip the file. You can review and download the 7-Zip tool here: https://www.7-zip.org/. If you need an alternative file zip format, please contact support.
When the file is ready, we will upload it to Google Drive and provide you with the link to download the file. After you have downloaded the file, we will remove the link to Google Drive and then provide you with the password to extract the file.
Database
The extracted file will contain a Database.bak file that will require SQL database software and some knowledge of SQL databases to access the data.
You can use Microsoft SQL Server Developer Edition (available at https://www.microsoft.com/en-ca/sql-server/sql-server-downloads) to mount the database file, subject to Microsoft’s terms and conditions. SQL Server Developer is a free edition of SQL Server for use in non-production environments.
To connect to the database, download and install the latest version of SQL Server Management Studio (SSMS) from https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.
After you have downloaded and opened SSMS connect using Server name: localhost. This setup assumes that you have installed these apps locally on your machine.
Once connected, in the Object Explorer, right-click Databases and select “Restore Database…”
Under Source, select “Device.”
Next to the Device text box, click the ellipsis (...) button.
Click Add.
Browse to the .bak file that was included with your data dump, then click OK. Note: By default, SQL Server runs as the SYSTEM user, so it won’t have access to any of your user’s files (e.g. Documents or Downloads). Place the .bak file in a directory that the SYSTEM user has access to.
Click OK in the Select backup devices window.
Click OK in the Restore Database window.
You will be notified that the database has been restored successfully. After dismissing the notification, the database will appear in the Object Explorer.
You can now review Tables, which will have all of your process data.
File Attachments
File attachments are included in the data dump if requested. They are organized by Process name, form title, and the original file name are included. Form file attachments will be organized in folders like "{Process name}/{Form title}/{File attachment ID} - {Original file name}". File attachments for other entities are organized similarly: "{Object type}/{Object name}/{File attachment ID} - {Original file name}" (e.g. "Agency/Your agency/1234 - Attachment.pdf").
Data Dump Support
As mentioned above, the data dump is meant as a one-time handoff that typically includes all data from your RPM subscription. To use this file you will require technical expertise or you will need to procure the necessary resources to use this file.