Defining an Open Hub Extract job in InfoSphere DataStage

In IBM® InfoSphere® DataStage® after creating the Open Hub Extract job and connecting an output link to it, you need to define the following parameters in a job including:

• Defining the Connection Parameters to a SAP BW System
• Selecting a Process Chain that is configured to perform the extraction in SAP BW, along with the Source System used to communicate with SAP BW.
• Selecting an InfoSpoke. The InfoSpoke specifies the data to be extracted and the manner in which it will be extracted (this includes filtering criteria, selection of InfoObjects, Delta vs. Full extraction, deletion of data before extraction.
• Metadata. The metadata describes the data that will be retrieved by the Pack. The metadata is retrieved from SAP BW and is transformed into corresponding InfoSphere DataStage columns. This metadata is used again to validate the data retrieved from SAP BW. This insures that the definition of the extraction data has not been modified in SAP BW since the job was designed.

IMPORTANT! An extraction that does not define all these parameters will fail.

Before beginning save your Open Hub Extract job.