Find Jobs
Hire Freelancers

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

$10-20 USD

Avslutat
Publicerad över nio år sedan

$10-20 USD

Betalning vid leverans
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....
Project ID: 7136398

Om projektet

4 anbud
Distansprojekt
Senaste aktivitet nio år sedan

Ute efter att tjäna lite pengar?

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram
Få betalt för ditt arbete
Beskriv ditt förslag
Det är gratis att registrera sig och att lägga anbud på uppdrag
4 frilansar lägger i genomsnitt anbud på $76 USD för detta uppdrag
Använd avatar
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 Om 6 dagar
5,0 (20 omdömen)
4,7
4,7
Använd avatar
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 Om 1 dag
5,0 (2 omdömen)
3,3
3,3
Använd avatar
Years of experience. Clean and optimised code. Master degree classes, High experience with many databases.
$72 USD Om 7 dagar
0,0 (0 omdömen)
0,0
0,0

Om kunden

Flagga för AFGHANISTAN
kabul, Afghanistan
5,0
71
Verifierad betalningsmetod
Medlem sedan jan. 11, 2014

Kundverifikation

Tack! Vi har skickat en länk för aktivering av gratis kredit.
Något gick fel med ditt e-postmeddelande. Vänligen försök igen.
Registrerade Användare Totalt antal jobb publicerade
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Laddar förhandsgranskning
Tillstånd beviljat för geolokalisering.
Din inloggningssession har löpt ut och du har blivit utloggad. Logga in igen.