In Progress

extract data from xml file and insert into oracle database

Instructions:

Table 1 (Equity):

EQU_SECURITY_REFERENCE_DATA

Table 2 (NON EQUITY):

NONEQU_SECURITY_REFERENCE_DATA

0) All the xml and xsd files are provided and we just need to refer them for extracting the data and save into oracle database table.

1) When the file mode is full then delete the entire data from the table and insert complete. The file mode can be decided by the file name.

2) When the file mode is delta then delete the already existing data by taking ID and insert new [login to view URL] file mode can be decided by the file name.

3) When the mode is delta or full then also check if the file is for equity or non equity and then insert into table accordingly.

4) there is very slight difference in xsd and xml file for equity and nonequity otherwise everything else is same

5) for less consumtion of memory you can create and read 10000 record for every session(this logic is already given in [login to view URL] and [login to view URL])

6) All the mechanism and logic can be refered from folder (old esma running take it for reference). We can refer the java files from [login to view URL](logic for db connection), [login to view URL](logic for unzipping file),

[login to view URL](logic for spring configuration), [login to view URL](logic for file directory and mode of file), [login to view URL](logic for reading xml file),

[login to view URL](logic for wiritng into database)

The full files will follow the following naming convention:

For Equities: FULECR_<Date>_<CFI 1st letter>_<Key1>of<Key2>.zip ----insert data into EQU_SECURITY_REFERENCE_DATA

For Non-Equities: FULNCR_<Date>_<CFI 1st letter>_<Key1>of<Key2>.zip ----insert data into NONEQU_SECURITY_REFERENCE_DATA

Examples:

[login to view URL]

[login to view URL]

The delta file will follow the following naming convention.

For Equities: DLTECR_<Date>_<Key1>of<Key2>.zip ----------insert data into EQU_SECURITY_REFERENCE_DATA

For Non-Equities: DLTNCR_<Date>_<Key1>of<Key2>.zip ----------insert data into NONEQU_SECURITY_REFERENCE_DATA

Examples:

[login to view URL]

[login to view URL]

All the files can be provided depending on request

Skills: Java, Oracle, XML

See more: oracle xml query examples, oracle xmltype extract multiple nodes, oracle extract xml tag value from clob, how to insert xml data into oracle table, oracle xml tutorial, how to extract xml data in oracle, how to insert xml data into clob column in oracle, oracle xml extract attribute value, methods extract data xml file net, extract data xml file posted web, extract data xml file, extract data xml file using 2008, extract data xml file sql server vbnet, extract data xml file vbnet, extract data xml file using net, vbscript extract data xml file, read xml file insert sql database, database function extract data xml file, extract data xml file save database, extract data xml file flex

About the Employer:
( 4 reviews ) Vaterstetten, Germany

Project ID: #24503336

Awarded to:

SamindaPeramuna

Hi I am a JAVA developer with over 8 years of experience and two of those are in the UK. Please refer to my profile for more information. I have had a look at the source code and snce I have worked on similar stuff b More

€50 EUR in 3 days
(61 Reviews)
5.8

24 freelancers are bidding on average €54 for this job

qprotex

Hello, My name is Miguel Febres and you can locate my resume and certifications in the following links: [login to view URL] [login to view URL] In my 10+ years of experien More

€70 EUR in 7 days
(46 Reviews)
6.5
paulprabhakarand

Hi Gentleman, I am a technology expert, more than a decade I am developing and delivering applications on Java based technologies. I am a certified Java professional. My logical thinking and problem solving skills are More

€70 EUR in 3 days
(50 Reviews)
5.9
rk123c

Hi, I’m a Java and oracle db expert. I’ve read the requirement and I can parse xml files and put into db. Please start a chat to discuss more details and start the work asap. Thanks

€70 EUR in 1 day
(27 Reviews)
5.0
rajitravindran

I am a Technical Lead and a Software Architect with almost 8 years of experience I have worked in both MNC as well as start ups where in which I was involved in end to end product development cycle. Am very strong in More

€70 EUR in 7 days
(21 Reviews)
4.8
prasantaghorui

Hi there, I am holding Master in Computer Application from a renowned university in India and currently I am a Senior Java Professional working in the IT development for last 15 years. My expertise includes Java,J2ee, More

€48 EUR in 3 days
(2 Reviews)
4.5
rnaushad

Hi there, I have about 15 years of experience in java and big data and associated frameworks like spring, hibernate, Spark, hadoop etc. I have developed a similar etl solution using XML based data for delta processing More

€77 EUR in 2 days
(10 Reviews)
3.8
Hada36

Hello, Thank you very much post your project. I am very much interested on your [login to view URL] my Experience and Expertise I believe and very confident that I will be able to handle your project efficiently and effect More

€55 EUR in 2 days
(23 Reviews)
4.4
soiganraducu

I can do this project for you. Let's discuss more details in private about the project. Looking forward to working with you!

€50 EUR in 7 days
(10 Reviews)
3.4
Syed23365

hello sir i am professional software engineer and i have years of experience of java and data base in oracle and in mongo db and i can complete the desired work before the timelimit and minimum of your budget sir

€39 EUR in 7 days
(7 Reviews)
3.5
engineeerrr

Hi.I have experienced about software engineering with Java over 4 years. And I gave alsı experienced XML parsing with SAX parser..Can you give detail about project on chat, I can do project perfectly and on time. We ca More

€66 EUR in 3 days
(6 Reviews)
2.3
AHarkous

Hello, I am a Java developer holding Masters degree in computer science. Your explanation for your requirements are very clear and straight forward, I can implement the whole program in 2 days from now, including unzip More

€50 EUR in 2 days
(2 Reviews)
1.4
Abhishekjavadev

I'm glad to bid to this project Check [login to view URL] and [login to view URL] develop spring boot+hibernate+ payment gateway integration develop and maintenance by me. Yes I can do this project for you because I have 7 More

€50 EUR in 7 days
(1 Review)
0.6
paythought

Hi I am a experienced Java developer with many years of developement, Can provide the solution you expect for. Look forward to a chat

€55 EUR in 7 days
(0 Reviews)
0.0
anushathaninki01

I have good experience with [login to view URL] give me a chance

€24 EUR in 10 days
(0 Reviews)
0.0
maheshmanam

Having 8 years of experience in database concepts and having real time experience in processing the files , able to help you to load the data in one day

€34 EUR in 1 day
(0 Reviews)
0.0
ashishkrishu1725

Hi Give me oppotrunity to give this work i will try best to deliver thanks ---------------------------------------------

€15 EUR in 7 days
(0 Reviews)
0.0
mriad1

Hello, I have a good experience using Java, Spring, and XML. I can see your problem and I had worked with XML files and I know very well how to get data from them. I will do your work ASAP if you give me this chance. G More

€40 EUR in 2 days
(0 Reviews)
0.0
farhanshafique2

I am an experienced SAP and Oracle Techno Functional Consultant with 10+ years’ experience in IT industry. Expert Knowledge on Order To Cash business process. • Exceptional expertise in using SQL, PLSQL, XML Publishe More

€55 EUR in 5 days
(0 Reviews)
0.0
madirajujobs

Dear Sir, Hope you are doing great! I am experienced developed working from java 1.1 version to 1.9. In my 15 years i worked on several investment banks and handled such requirements . I am sure that i can provide More

€39 EUR in 7 days
(0 Reviews)
0.0
DenisaBianca10

hello, i can do this project for you very soon. we can send me the details about your project in private .

€60 EUR in 7 days
(0 Reviews)
0.0