We've got a basic data warehouse setup using a MySQL database on a hosted linux server.
We receive data daily from 3 CSV files via FTP, that we currently download and then upload into 3 different tables in mysql manually each morning. There are then a number of queries that are run to clean and transform the data and move to final tables.
I'm looking for someone to design and code a solution to:
- automate the downloading of the 3 csv files each morning
- upload each file into a different table in the database
- run SQL code relating to each loaded file
with an explanation and instructions for implementing
47 freelancere byder i gennemsnit $169 på dette job
This is something I am expert in. Have good experience in data migration and automation and can make your process simpler for you as defined. Please let me know when we can discuss in detail and process further.
Dear Sir, I have done similar projects This project easy to me, I can create a stand alone app (desktop app) to meet your requests I am looking forward your response. Best Regards Duc
Hello, Hope you are doing well. I have 6 years of experience on Linux and Mysql. I will automate Loadig Daily CSV from FTP into Mysql Regards, Vishnu