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