Forgive me for what may be a simple question. I've never had to work with this scenario before.
We have a client who wants a very basic website that lists their products. But the database population and updating is a little tricky.
They have their own SQL database (Active db, navision C/side) used internally for their products.
Every night, they want to put an updated dump file or csv file into their server's DMZ.
From there, they want us to access it to populate a database on the server hosting their website, so we can show the available products online. But I don't know how we access remotely to that file so we can do what we need to do - let alone doing it automatically!
This is a little above my pay-grade, as they say.
Any help on how to achieve this would be greatly appreciated!