PHP or JAVA script to load data in database ETL -- 2

$10-20 USD

Κλειστή

Αναρτήθηκε

περίπου 9 χρόνια πριν

$10-20 USD

Πληρωμή κατά την παράδοση

PS: make sure you know about bulk loading of mysql/sql server and also about sqlldr for oracle and also "copy from" in PostgreSQL... don't bid if you don't know what you talking about!! I need a scrip something like ETL in PHP that will take care of the following database, each on its own class well documented: - one class to load data in MySQL, - one class to load in Postgres's - one class to load in oracle - one class to load in sql server all class should be flexible so I can run any of them that I need and rest will be disabled.... all class must be able in a way to load file loaded in separate table and make sure not to load same file two times.... after loading any files it should .. - rename the file to loaded at the end of the file - and load that file with timestamp to separate table so make sure it will not load it again next time when it check it... please write YES if you read all description it's important to me and only bid if you can do this....

Ταυτότητα εργασίας: 7136398

Σχετικά με την εργασία

4 προτάσεις

Απομακρυσμένη Εργασία

Ενεργός/ή 9 χρόνια πριν

Ψάχνεις τρόπο για να κερδίσεις μερικά χρήματα;

Διεύθυνση Email

Πλεονεκτήματα πλειοδοσίας στο Freelancer

Καθόρισε τον προϋπολογισμό σου και το χρονοδιάγραμμα

Πληρώσου για τη δουλειά σου

Περίγραψε την πρόταση σου

Η εγγραφή και η πλειοδοσία σε εργασίες είναι δωρεάν

4 freelancers δίνουν μια μέση προσφορά $76 USD για αυτή τη δουλειά

@irondrake

YES I've done several handcrafted ETL's in the past, I can do it customizable, soyou can map the fields from the file to the fields from the table, specify the table to the PHP class, and be aware of not duplicating the file by using the filename.

$100 USD σε 6 ημέρες

5,0

(20 αξιολογήσεις)

4,7

@WebDevPro007

I can provide it to you in JAVA. 4 scripts than will scan a directory, select all files (filename should have a specific structure) transform is necessary and load all the files into the database. After loading, you have a logfile contening : file name, process start date, porcess end date, number of rows read, number of rows inserted, number of rows rejected ... All the rejected rows will be available for future anlaysis. you will just need to specify : sourceFileDir, DBHost, DBlogin, DBpwd, ... If you agree, I will start it now

$111 USD σε 1 ημέρα