I would suggest creating a drush command that retreives and saves the data via batch or queue. This article may come handy :).
mojzis
- 2.5k
- 1
- 20
- 26