What transforms can I use to modify data in a database ?
Alex Wood 120000PC5E Comment (1) Visits (3805)
In WebSphere Message Broker v8 and IBM Integration Bus v9, you can set database tables as additional outputs of a message map.In the Graphical Data Mapping editor, you can use any of the following transforms to modify data in a database:
Note: Only IBM DB2 stored procedures are supported in IBM Integration Bus .
To be able to use these transforms at design time, you must have a database definition file (.dbm file) in an available Data Design project for each database that you want to access. A data definition file contains one connection per database system.
To run a message map that modifies data in a database, you must have a JDBC connection of Type 4 defined for each database that your message map uses. You must configure a JDBCProvider configurable service per database. The JDBCProvider service name for a runtime database must be the same name as the development database name that you use during the design phase in your message map.