Does the SPC do a cloud dump of the DB at regular interval or does the API communicate directly with the SPC?

SPC reads every night at 2 am local time.  The cloud and the API are available for you 24/7. 

SPC can be configured to extract data at 15 min ( minimum ) intervals based on your API license.