Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to do Database to XML conversion using ODI 12c

3405158Feb 27 2017 — edited Feb 27 2017

Hi,

I have a database table and I want to create a XML FILE using the data in the table.

My xml structure is as below.

<?xml version="1.0" encoding="UTF-8"?>

<Employees>

<Employee>

<FirstName>nananenene</FirstName>

<LastName>ghfhgf</LastName>

<Age>26</Age>

<Organization>dsdsfsf</Organization>

</Employee>

<Employee>

<FirstName>werrrrr</FirstName>

<LastName>cfddee</LastName>

<Age>27</Age>

<Organization>ffrttgg</Organization>

</Employee>

</Employees>

Please help me.

I have tried to create the same by the sample xml is getting generated in the target xml folder.
This post has been answered by Suman Kishtadi on Feb 27 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2017
Added on Feb 27 2017
#business-intelligence-applications, #data-integrator, #system-management-and-integration
10 comments
729 views