The methodology of pulling data out of one software system (via some sort of application programming interface or API) and putting it into a database or other system is commonly referred to as an Extract-Transform-Load (ETL) process. There is also advocacy for ELT patterns (transforming last), but regardless of the location of the T I’ve found that the E and L parts are the most critical. In terms of operational efficiency and the need for constant maintenance, the acquisition of data (E) and storage (L) have to be bug free and running cleanly.