webMethods step by step Database to Database
Jan 18, 2012 10:43 0 Comments Development Pia

TASK: DataBase-To-DataBase

OS: WindowsOS

Platform: webMethods 6.1


This Scenario tells that, how to take the data from an SQL Server Table into another table in the database. 

To do this the following FlowSteps are used. 

1.    DBToDB: SelectSql

2.    DBToDB: BatchInsertSql 

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) and (BatchInsert) Adapterservices. For this refer the document How to create a JDBCAdapter Services.


Flow Steps in detail….

1. DBToDB: SelectSql

This flow is the  created selectJDBCAdapterService that is invoked thru insert flow step.




To call this service using remote invoke method,using this service store group of records from table into the database. 

Map ‘SelectTableOutput’ in Pipeline In à ‘BatchInsertSqlInput’ in Service In




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