webMethods step by step Flat file to Database
Jan 20, 2012 14:10 0 Comments Development Neelima

 


Task: Flat file to Database

OS: WindowsOS

Platform: webMethods 6.1


 

This task takes the data from the flat file and writes into the table (Employee)(SQL Server). 

To do this the following FlowSteps are used.. 

  1. pub.file: getFile
  2. pub.flatFile:convertToValues
  3. Transformations.FlatFile2DB: bins (Batch Insert Adapter Service) 

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 (BatchInsert)Adapterservice.  For this refer How to create a JDBCAdapter Service.

 FlowSteps in detail….

 1. pub.file:getFile: 

This flow step reads the data according to the specified path and converts into bytes.

Mapping for this flow step

alt


 

2. pub.flatFile:convertToValues 

ConvertToValues service is used to convert the bytes into a ffValues using the flat file schema. (For creating flat file Schema refer How to Create flat file Schema?)

            Mapping for this flow step.

alt


 

3.Transformations.FlatFile2DB: batchinsert 

This flow is the  created selectJDBCAdapterService that is put the data thru Batch Insert flow step into database. 

Mapping for this flow step.

alt


 

 

 

 

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