Processing SAP BW selection parameters

This section describes the necessary components, coding, and flow of passing selection parameters from SAP BW into IBM® InfoSphere® DataStage® jobs.

Loading data from non-SAP systems into SAP BW requires extraction of data from many different data sources. Many data sources are relational database systems, requiring queries to be generated that select only parts of the source data. In some cases the selection criteria must be dynamic, based on the information required within SAP BW. The selection parameters defined within SAP BW are available as a single parameter to InfoSphere DataStage. The next section describes how to understand, parse, and utilize this new BWFILTERS parameter within InfoSphere DataStage jobs.