How Can We Help?
Extracting data from PureExtracting data from Pure
If you should come to the point where your Pure contract with Elsevier runs out and you need to migrate data to another system, you will need a migration strategy. The primary goal of the migration strategy is to extract your data and to ensure that your data is no longer in Elsevier's possession following the termination of your Pure contract. In addition, it is important that the data can be migrated to another system, and that the whole process is controlled by you.
Should you come that far, we are sorry to see you leave the Pure Community. This document will give you an overview of the tasks needed and an idea of the timelines needed. Please note that you will need to make your own assessment and investigation on how to perform the migration strategy with the resources and skills of your local team or a third party contractor.
Overall Process
The overall generic process of an exit plan is comprised of the following steps:
- Extract data from Pure in a structured format.
- Store data at your controlled storage.
- Shutdown and delete any Pure system hosted for you by Elsevier.
- Transform data to the desired ingestion format for your new Research Information Management System (RIMS).
- Ingest data into the new RIMS.
To accomplish the above, Pure comes with a web service capable of extracting data, and Elsevier provides support via our online Pure support system https://psp.elsevier.com/ for the duration of your Pure contract. The actual extraction and transformation of data is your responsibility.
Extract data from Pure
Pure comes out-of-the-box with a web service enabled. Therefore extraction of data can be done at any time during your Pure contract. Many Pure clients use the Pure web service to extract and feed data into an internal data warehouse, a reporting engine, internal or external staff web pages, or another campus system.
Data extraction is performed using the Pure web service, which allows extraction of both metadata and file data in XML and JSON format. The choice of format usually depends on the format for ingestion into the new RIMS. For example if the new system requires XML, then extracting data from Pure in XML is preferred.
Using a web service requires either an ETL (Extract, Transform, and Load) tool or programming skills and some experience in working with web services. For an experienced programmer with a general understanding of web services, extraction will take from one to a few days work to create the program, and then a couple of days to extract the data, depending on the amount of data you have in Pure.
Please find information about the Pure web service here or Pure API:
- For general information on the webservice and API please see Classic (read-only) Webservices and the Pure API - Getting data in and out of Pure
- For classic webservice navigate to:
https://<your-pure-server>/ws
- here you will find the interactive web service documentation on your Pure server. - If Pure API is enabled navigate to: https://<your-pure-server>/ws/api - here you will find the interactive documentation for the Pure API
- Master Classes in Pure - here you will find some webinars on using the web service.
Shutdown Pure and delete Elsevier-hosted data
When your data is securely stored on your controlled storage we can delete any data and Pure system hosted on Elsevier's infrastructure. This is done either upon your request to us (via Client community) or at latest when your Pure contract runs out.
Transform and ingest data into new system
Transformation of data to the desired ingestion format can be done in several ways, usually either via an ETL tool or direct programming. You should ask the vendor of your new system to assist or guide you in getting data transformed into the correct format for ingestion into your new system.
This part will resemble a full Pure implementation project, and you can expect it to take any time from a few weeks to several months depending on your resources and the help and guidance provided by the vendor of your new system or a third party contractor.
Updated at July 27, 2024