We have a integration requirement where we have to read the xml response from the API request and then parse the xml and insert them into the table. Proposal is to use Java.
Proposal is to use Java. But I'm very new to JAVA and APIs as my background is mainly on the database and SQL. Based on the requirement i have done my research from past 3 days and came up with the below solution.
I have divided this into 3 parts
- Reading the XML : Use Java/Spring to read the API xml response
- Parsing the XML : Use JAXB to parse the xml and get the needed fields
- Loading them into the database : Use Hibernate to load it into the database
Please suggest if this will work or are there any better ways? Please let me know if this is not the right forum to ask this question i will then delete my post. I'm not looking for any code but just the architectural point of view of how we can go ahead here.