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.

 

| More Free Trial For New Buyers
 

Status:

Selected Providers: expertMan

Budget: $250-750

Created: 10/01/2009 at 17:27 EDT

Bid Count: 24

Average Bid:
$ 378

10/06/2009 at 17:27 EDT

Project Creator: db4red
Employer Rating: 10/1010/1010/1010/1010/1010/1010/1010/1010/1010/10 (1 reviews)

Bid On This Project
 

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

Messages Posted:0 View project clarification board Post message on project clarification board

Bid On This Project
 

If you are the project creator or one of the bidders Log In for more options

 

250

3 days

10-02-2009 04:01 EDT

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

help

 

300

5 days

10-05-2009 01:31 EDT

ready for your work

help

 

730

15 days

10-01-2009 19:00 EDT

We're interested in this project. Take a look on our portfolio at: http://www.a2design.biz/portfolio_

help

 

250

0 days

10-02-2009 06:36 EDT

Easy for me!

help

 

300

5 days

10-02-2009 07:30 EDT

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 network folders on a user defined time interval using a VB.Net Win Client application. Please have a look at our profile to know more about us and feel free to contact us. Thank you

help

 

400

10 days

10-01-2009 22:51 EDT

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

help

 

300

10 days

10-02-2009 03:00 EDT

Please have a look at my PM. Thanks.

help

 

250

10 days

10-02-2009 12:18 EDT

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

help

 

300

3 days

10-01-2009 18:29 EDT

(No Feedback Yet)

Please check the PMB

help

 

400

10 days

10-02-2009 23:49 EDT

(No Feedback Yet)

Our vision is quality and affordability. We can provide a quality solution. Now it is your call.

help

 

350

5 days

10-02-2009 00:38 EDT

(No Feedback Yet)

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 programming experience. I will code in VB .NET. Your server/client machine will need .NET 2.0 framework installed. If your system already have Oracle for .NET installed, that will be great. Please let me know if you have any question. Thank you very much for reviewing my bid. Sincerely, Mehdi Anis St. Cloud, MN

help

 

400

5 days

10-02-2009 02:23 EDT

(No Feedback Yet)

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

help

 

300

12 days

10-02-2009 02:43 EDT

(No Feedback Yet)

Hello, Please check the PMB to know more about us. Thanks a lot kloudz Team

help

 

250

5 days

10-02-2009 03:09 EDT

(No Feedback Yet)

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

help

 

250

5 days

10-02-2009 04:43 EDT

(No Feedback Yet)

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

help

 

500

5 days

10-02-2009 05:48 EDT

(No Feedback Yet)

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

help

 

600

15 days

10-02-2009 08:55 EDT

(No Feedback Yet)

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 me know if you want me to work on this. FYI: i do have US t-mobile number, if you sanction me this project i can share that number with you. Regards, Madhukar

help

 

400

10 days

10-02-2009 12:56 EDT

(No Feedback Yet)

Please check my PM

help

 

250

20 days

10-03-2009 11:33 EDT

(No Feedback Yet)

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

help

 

250

5 days

10-04-2009 07:56 EDT

(No Feedback Yet)

Hi, Please check your PMB. Thanks

help

 

650

15 days

10-04-2009 12:28 EDT

(No Feedback Yet)

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

help

 

390

30 days

10-05-2009 01:10 EDT

(No Feedback Yet)

fvbvcxb vcbvcbvcbvcbvcbvcbvcbvcbvcbvcbvcbcfbcvbvcbvcbvcbvcbvcbvcbvcbc

help

 

250

5 days

10-05-2009 06:26 EDT

(No Feedback Yet)

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 site, but given an opportunity, I will not let you down.

help

 

750

10 days

10-05-2009 14:05 EDT

(No Feedback Yet)

can i build this application with powerbuilder and i will give you an exe file to be run any where

help


    Bid on this Project