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

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.

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.