webMethods step by step Database to Flat file
Jan 18, 2012 15:24 1 Comments Development Pia

TASK: DataBase To FlatFile 

OS: WindowsOS

Platform: webMethods 6.1



This task takes the data from a database table (Employee)(SQL Server) and writes it

 in a form of flat file. 

To achieve it following Flow Steps are used… 

  1. DBToFF: SelectAdapter
  2. Pub.flatFile: convertToString
  3. Sample.IO.test: writeToFile 

Before using the flow steps we need to create a JDBC Adapter Connector. For creating JDBC Connector refer the document How To Create JDBCConnector.doc and also we need to create a JDBC (select) Adapter service. For this refer the document How to create a JDBCAdapter Service. 

Flow Steps in detail…. 

DBToFF: SelectAdapter 

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 SESQLOutput DOC.


2. pub.flatFile: convertToString 

ConvertToString service is used to convert the SESQLOutput IDOC into a string using the flat file schema. (For creating FlatFile Schema refer How to Create FlatFile Schema?)  

            Mapping for this flow step.



à OverwriteFlag must be specified to overwrite/Append  



Prev Next
About the Author
Topic Replies (1)
  1. 1
    idnkx user


    Hi, I tried with webMethods 9.5, but doesn't work! How can I convert it to 9.5? Thanks

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