Hi,
We have a reply from CMX engineering regarding best practices on exporting CMX 10 data for offline use.
In general, I think the philosophy is to provide APIs and not directly consume the underlying databases – postgres and Cassandra. As we port things to the cloud, we are changing the underlying databases even though the APIs may be roughly staying the same.
Another strategy which may be more useful is to use the northbound notifications and have them sent to a restful service that the customer provides. In this way, their own program collects the data and then they can store it however they see fit in their own databases. For scale, this works best.
I hope this helps.