Hi.
OK.
You have a specific requirement.
There is no solution that can simply connect to your external server and retrieve data from the database.
There are clouds of universal solutions for importing XML products, but none of the ones you need.
We are still talking about something, but nothing specific.
Are you a module developer for Prestashop?
https://addons.prestashop.com/en/search?search_query=XMLimport