Need to create an automated system that (possibly using dropbox functionality, unless alternative suggested):
1. Auto-creates ODBC DSN on remote client
2. Auto-refreshes linked ODBC tables to Access DB (sitting in shared dropbox folder. Default access tables pre-defined)
3. Auto-uploaded Access DB to local SQL Server DW
4. This process repeated for Multiple clients, uploading into single SQL DW
Am open to suggestions if alternative process deemed more efficient, though have limited local hardware available.
Basically, need to retrieve data from remote odbc connected databases, and upload and consolidate into a local data warehouse.
23 freelance ont fait une offre moyenne de 525 $ pour ce travail
Hello, We will be keen in taking this up. We will provide you with single point of contact, who will be available on skype or any other IM's. Kindly check the PMB. Regards, Credent Team.
I have the experience and the knowledge to make you business needs a success. i am very fluent in ADO.net and i would be a pleasure to work along with you