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 %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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

$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)