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
45 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I can automate the function to load csv from FTP to MySQl, please contact to discuss in detail and move further, thanks. Relevant Skills and Experience MySQL
Hello I just starting work like freelancer and I want get few references on my work. So I can write some scripts for free for you and then we can collaborate on long term base.
Recently we complete a similar project (large scale) in oracle for health records. The system collects files from various ftp sites and load them in db table.
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
hi, I have completed more than 10 projects like this using pentaho data integration tool for airline, fmcg, retail domain. I have done in Linux and windows environment with mysql database and cron schedule.