Select

Use the Select transform to retrieve data from rows in a database table, so that the data can be used in a message map.

For more information, see Selecting data from a table.

When you design your message map in the IBM® App Connect Enterprise Toolkit, the database server that is used during the creation of your Select transform is specified in the database definition file (.dbm file) that you selected from the Data Design project used to create the message map.

When your message map has been deployed to an integration server, and your message map is run, the database server that is used by the IBM App Connect Enterprise runtime component to process your Select transform is specified by the JDBC Providers policy. The JDBC Providers policy name must be the same name as the database name that is specified in your Select transform during development.