webMethods step by step Database to XML file
Jan 18, 2012 15:43 0 Comments Development Pia

TASK: DataBase To XML

OS: WindowsOS

Platform: webMethods 6.1

 In this task data is retrieved from a table (Employee)(SQL Server) and is written to a file in XML format. 

To achieve this, the following Flow Steps are used… 

1.    dbtoxml: selecttab

2.    pub.xml: documentToXMLString

            3.  sample.IO.test: writeToFile 

Before this u need to create a JDBC Adapter Connector. For Creating JDBC Connector refer the document How To Create JDBCConnector.doc and create a JDBC (select)Adapterservice. For this refer the document How to create a JDBCAdapter Service. 

FlowSteps in detail…. 

1. dbtoxml: selecttab 

This flow step is created using selectJDBCAdapterService that is invoked through insert flow step.


After executing this step the records in the table (Employee) are shown in the SelectsqlOutput IDOC

2. pub.xml: documentToXMLString 

documentToString service is used to convert the SelectsqlOutput IDOC into xml data.         

Mapping for this flow step.


3. sample.IO.test: writeToFile: 

This flow takes the xmldata and writes into the XML file according to the specified path. 

Mapping for this flow step.


à OverwriteFlag must be specified to overwrite/Append  

Prev Next
About the Author
Topic Replies (0)
Leave a Reply
Guest User

You might also like

Not sure what course is right for you?

Choose the right course for you.
Get the help of our experts and find a course that best suits your needs.

Let`s Connect