READ THIS FIRST!!!
Ok. We are building an .ASP NET webshop.
The webshop will have its own Microsoft SQL Database (DB1) for its own products.
The owner has a contract with a third party dropshipper who has +100K products, the dropshipper delivers a URL from where we can pull the product feed.
We want a second database (DB2) which will hold all products imported from the dropshipper.
In our illustration (see attachment) you can see the setup.
We want the dropshipper (illustrated as DB3) to communicate with DB2 and update itself daily automatically where it will add new products, update stock and prices etc.
I need someone who can make the connection and automation between DB2 and the dropshipper + the automatic updates. Keep in mind that the productfeed comes with more columns then we need, so it has to automatically map the columns we need and disregard the ones we dont.
see picture and reply only if you have read the case!