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.

DBToDB:BatchInsertSql

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