# Read dynamic xml data and store it in databse using CloverETL

**URL:** <https://forum.cloverdx.com/t/read-dynamic-xml-data-and-store-it-in-databse-using-cloveretl/1866>\
**Category:** CloverDX Platform\
**Created:** [May 25, 2017, 12:00am UTC](https://forum.cloverdx.com/t/read-dynamic-xml-data-and-store-it-in-databse-using-cloveretl/1866 "2017-05-25T00:00:00Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sasusri](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@sasusri](https://forum.cloverdx.com/u/sasusri)\
**Post date:** [May 25, 2017, 12:00am UTC](https://forum.cloverdx.com/t/read-dynamic-xml-data-and-store-it-in-databse-using-cloveretl/1866/1 "2017-05-25T00:00:00Z")

</div>

Hi Guys,

Could you please help me on reading XML data(Where xml files will be different in each time) and store the data into databases.

I am very new to CloverETL, and I could see some post related XML Reader and XML Extract but I am not sure how to use it on our applications and how to call those.

Please help me on this as soon as possible.

Thanks in Advance!  
Sai Chaitanya

---

<div class="post-metadata">

**Author:** ![sasusri](https://avatars.discourse-cdn.com/v4/letter/s/4af34b/32.png) [@sasusri](https://forum.cloverdx.com/u/sasusri)\
**Post date:** [May 26, 2017, 8:40am UTC](https://forum.cloverdx.com/t/read-dynamic-xml-data-and-store-it-in-databse-using-cloveretl/1866/2 "2017-05-26T08:40:43Z")

</div>

Can some one help me on this its very urgent requirement.  
Thank you!

---

<div class="post-metadata">

**Author:** ![Vladimir\_Barton](https://yyz1.discourse-cdn.com/flex007/user_avatar/forum.cloverdx.com/vladimir_barton/32/167_2.png) [@Vladimir\_Barton](https://forum.cloverdx.com/u/Vladimir_Barton)\
**Post date:** [May 29, 2017, 1:12pm UTC](https://forum.cloverdx.com/t/read-dynamic-xml-data-and-store-it-in-databse-using-cloveretl/1866/3 "2017-05-29T13:12:20Z")

</div>

Hello Sai,  
let’s break this down into 2 separate topics based on your question: reading data from XML files and writing the data into databases.  
A. Reading XML files  
There are several options how you can read the XML files using the CloverETL Designer. It can be done either by using the XMLExtract, XMLReader or XMLPathReader component. Generally, it is suggested to use the XMLExtract as it can offer a graphical user interface that would help you map elements to records. All you need to do to make the XMExtract component work is to fill in the source File URL and define the Mapping. Please find more information about the mapping in our [online documentation for CloverETL Designer](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/xmlextract.html) or in the following video, although it concerns an older Clover version ([https://youtu.be/18jkmcMI11M](https://youtu.be/18jkmcMI11M)).  
B. Writing into databases  
There are also many options in the CloverETL Designer how to write data into a database. In general, it is recommended to use the DBOutputTable component that is capable of writing into many different sorts of databases by using the JDBC driver. Feel free to review the [detailed instructions](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/dboutputtable.html) on how to use this component.  
CloverETL Designer also provides a number of specialized database writer components that can be useful in specific scenarios. However, they generally require a more complex setup and might also demonstrate certain limitations (e.g. both the Designer and the database must reside on the same machine in some cases). Picking the proper database writer component also largely depends on which sort of database you need to write the data into, for example, HadoopWriter (writes into the Hadoop database), MongoDBWriter (writes into the Mongo database), MSQLDataWriter (writes into the MS SQL database) etc. I would suggest reading our [CloverETL Designer documentation](http://doc.cloveretl.com/documentation/UserGuide/index.jsp?topic=/com.cloveretl.gui.docs/docs/writers.html) for the specific database writer component that you might consider to use.  
You can also find much useful information on our CloverETL Forum while searching for particular keywords ([http://forum.cloveretl.com/](http://forum.cloveretl.com/)).  
If you are looking for more specific information or if you are facing a particular issue with your CloverETL graph, feel free to come back to us with a specific question, screenshot or attachment.  
Regards,