Hi, I am testing my ecommerce web app based on Django and I would like regularly import data from outside database. I work in warehouse that has the ERP system. There is possibility to extract from there such data I need. I thought about it to create on our company server a database that would contain such data as price_A, price_B, price_C, quantity, name, code and id of products. Let's call it Mydb. This database would be synchronized with ERP database. I would like to import data from Mydb to ecommerce database on PythonAnywhere (let's say once a day).
In conclusion, I would like my ecommerce web app with own database work on PythonAnywhere but I would like to be able to import data from my company server. Because I need to have relatively up-to-date data in my web app.
What is the best way to do this on PythonAnywhere?