Extract xml from Oracle Db then reload in another Oracle DB

Summary Process:

Note the following takes place using Oracle databases on Windows Client and Server

I need a process to poll a database at regular intervals, extract records as separate xml files and post them along with other files named in fields within the database record to a network ‘Receiving’ folder.

A second process polls the Receiving folder, picks up the xml file and inserts it into a database.

Process Detail

Every n seconds,

Read Table X, if records are present, extract each record into separate xml files located in a ‘Pending’ folder, one file per record. The xml filename is based on sysdate and a concatenation of columns in the database eg format(sysdate, ‘yyyymmdd’) || X.column_A || X.column_B || ‘.xml’.

The record also contains a field containing another filename (X.file_name) which accompanies the xml file. This field containing the filename will also exist within the xml file as it is extracted from the database record. The other file is contained in a folder c:\Ready_to_go\ and is a relatively large file c5Mb

Both the xml file and the accompanying file need to be posted/copied to a network folder. Say the folder is called ‘Received’. The Other file must be posted first, the xml file is posted second.

Another separate process takes place polling the ‘Received’ folder. It picks up the xml file, based on the file_name tag, the process checks for the existence of the accompanying file, if all is well, the xml data is inserted into another database and both the xml file and the accompanying file will be moved to a ‘Processed’ folder.

Write to audit database

End of process.

Error handling must be carried out throughout the process

Taidot: Javascript, Oracle, SQL, Visual Basic, XML

Näytä lisää: extract xml within oracle, n. y. post, audit format, audit file, oracle extract xml, javascript data format, audit process, xml post, summary table, picks, oracle data, Extract, database oracle, extract javascript, read write server using, javascript xml table, reload file, windows process network, polling windows folder file, windows oracle, xml client, extract records, table extract, extract filename, polling database

Tietoa työnantajasta:
( 19 arvostelua ) Birmingham, United Kingdom

Projektin tunnus: #519463

Myönnetty käyttäjälle:


ready for your work

300 $ USD 5 päivässä
(26 arvostelua)

24 freelanceria on tarjonnut keskimäärin 378 $ tähän työhön


We're interested in this project. Take a look on our portfolio at: [url removed, login to view]

730 $ USD 15 päivässä
(10 arvostelua)

We can help in your project, please check PMB to see our related experience.

250 $ USD 3 päivässä
(49 arvostelua)

Hi, I can provide you the required solution. Please check PMB. Regards.

400 $ USD 10 päivässä
(11 arvostelua)

Hi, I am a full time Oracle programmer and .NET application developer. In my every day work I do similar tasks. I am confident that I can complete this task successfully within given time. I have several years of p Lisää

350 $ USD 5 päivässä
(22 arvostelua)

Easy for me!

250 $ USD 0 päivässä
(8 arvostelua)

Hi, Please check your PMB. Thanks

250 $ USD 5 päivässä
(3 arvostelua)

Please have a look at my PM. Thanks.

300 $ USD 10 päivässä
(3 arvostelua)

I would be able to help you on this. Please refer PMB. Regards Harry

400 $ USD 5 päivässä
(5 arvostelua)

Hi! We have a vast experience in Oracle PL/SQL under 9i and 10g databases, Forms 6i / 9i and Java application and we'll be glad to help you with the project. Regards, George

250 $ USD 10 päivässä
(1 arvostelu)

Please check the PMB

300 $ USD 3 päivässä
(0 arvostelua)

Hello I am very very interested in working on this project. As an ETL Developer working for huge corporations, I have a very good experience working with XML, Oracle, PL/SQL and SQL. I don't have any references on this Lisää

250 $ USD 5 päivässä
(0 arvostelua)

fvbvcxb vcbvcbvcbvcbvcbvcbvcbvcbvcbvcbvcbcfbcvbvcbvcbvcbvcbvcbvcbvcbc

390 $ USD 30 päivässä
(0 arvostelua)

Hi, I have extensive experience in Enterprise software development & deployment. Please check PM for further details. Thanks, Rishikesh R.

650 $ USD 15 päivässä
(0 arvostelua)

Well i ve set 20 days but if we could get a regular chat icq or smthing - it ll be smooth and faster

250 $ USD 20 päivässä
(0 arvostelua)

Please check my PM

400 $ USD 10 päivässä
(0 arvostelua)

Hi, I can do this using Quartz and Java. Have previously worked on polling, db and xml applications before.

500 $ USD 5 päivässä
(0 arvostelua)

Hi, This is around 30hrs work, i can complete this by working 2hrs every day. if its urgent i can complete this as per you deadline. I have done same kind of work in my previous project. I charge $20 / hr. Let Lisää

600 $ USD 15 päivässä
(0 arvostelua)

Hi, we can complete this project for you. In past we did a similar project for a medical transcription company for processing large number of xml and rtf files, database records processing and files reading/writing on Lisää

300 $ USD 5 päivässä
(0 arvostelua)

i have been a programmer for past 5 years i can do this with out any bugs :) pls give me details :)

250 $ USD 5 päivässä
(0 arvostelua)

i have 2 yr exp in bk up and restore db into xml,database to another db, i can reduce the payment also kshankar india

250 $ USD 5 päivässä
(0 arvostelua)