How Can We Help?
Get Data Out of Pure Without Using the Report ModulesGet Data Out of Pure Without Using the Report Modules
What
Is there a way to get data out of Pure for reporting purposes without using the Report Module?
How
Web Service/API
In general, the Web Service/API is not as such considered a reporting tool, where you can do advanced reports. We recommend the New and the Classic Report Module for extracting data for reporting purposes. It is up to you, if you prefer using the Web Service/API for extracting data for reporting.
Database Dump
Doing a data base dump will only give you a snapshot of the data right now, so reporting from this would very quickly be outdated.
We use Hibernate and the structure of the data is not readable without a massive amount of work to understand and restructure it – and for each release this will probably change, so you will need to do this massive task over and over.
Elsevier will not provide support for this.
Finally, a database dump does not contain the full data, if running the "Audit Entry Archiver" job, the job checks if there is more than 100.000 rows in the audit log database tables, and if there is, the audit data is moved to zip files in the file system, so some of the audit logs are stored outside the database.
More information
Note: Some of this information is for internal use only and might not be accessible.
Written by Anette Rosendahl Pedersen on October 15, 2023
Updated at October 24, 2023