Project Detail
Extract xml from Oracle Db then reload in another Oracle DB
Extract xml from Oracle Db then reload in another Oracle DB is project number 519463
posted at Freelancer.com. Click here to post your own project.
Bid Count: 24
Average Bid:
$ 378
10/06/2009 at 17:27 EDT
Project Creator:
db4red
Employer Rating: 
(1 reviews)
Description
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
|
Job Type |
|
Provider Rating
WHAT IS FREELANCER.COM?
Freelancer.com is a global outsourcing solution and freelance jobs website. Here you can find freelance coders, writers, programmers, designers, marketers and more. You can also outsource projects and save a lot of money in the process. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier!
We have thousands of satisfied clients from every corner of the world. Would you like to outsource your next project? Would you like to find freelance jobs and make money online? Just sign up to get started!
Outsourcing jobs is the process of hiring an outside company or individual to complete your projects. We have created a safe environment for both service buyers and service providers via our secure payment system. You outsource the project and don't release any money until you're satisfied! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.
- Plendo Sweden AB © 2004-2009
- PRIVACY POLICY
- TERMS
- AFFILIATES
- API
- QUOTES
- CONTACT
Freelancer™ is a trademark of Ignition Networks Pty Limited (ACN 134 845 748)
Newly Outsourced Projects fed by 
Follow our Freelance Jobs on Twitter 
Add to your
Google search results
Software & Free Downloads * Webmaster Resources * Webmaster Forum