Suoritettu

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:

expertMan

ready for your work

$300 USD 5 päivässä
(26 Arvostelua)
5.8

24 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

A2Design

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)
6.7
SigmaVisual

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

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

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

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

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)
4.8
kamosion

Easy for me!

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

Hi, Please check your PMB. Thanks

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

Please have a look at my PM. Thanks.

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

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

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

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)
1.4
etechnohub

Please check the PMB

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

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)
0.0
rakeskul

fvbvcxb vcbvcbvcbvcbvcbvcbvcbvcbvcbvcbvcbcfbcvbvcbvcbvcbvcbvcbvcbvcbc

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

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)
0.0
sib82dmitri

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)
0.0
pako1144

Please check my PM

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

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)
0.0
bid2oracle

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)
0.0
novelwebstudio

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)
0.0
DamithaKaushalya

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)
0.0
shankaronbid

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