See information about the latest product version
Select
The Select transform retrieves data from rows in a database table, so that the data can be used in a graphical data map.
Use the Select transform to retrieve data from rows in a database table, so that the data can be used in a graphical data map. For more information, see Selecting data from a table.
When you design your graphical data map in the IBM® Integration 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 map.
When your graphical data map has been deployed to an execution group, and your map is run, the database server that is used by the IBM Integration Bus runtime component to process your Select transform is specified by the JDBCProvider service that has the same name as the database that is specified in your Select transform. For more information, see Enabling JDBC connections to the databases.
For information about the Mapping node, see Mapping node.