webMethods step by step Flat file to Database
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..
- pub.file: getFile
- pub.flatFile:convertToValues
- 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.
