Functionality

The Load stage lets you load data directly into SAP BW systems and integrate it with data from other sources, using the visual design process of IBM® InfoSphere® DataStage® for modeling and deploying source-to-target transformations and loads.

This stage has the following functionality:

  • Lets you create and modify SAP BW InfoObjects (Characteristics and Key Figures) based on column level metadata as represented in InfoSphere DataStage Table Definitions, job links, and so forth.
  • Lets you create InfoSources that are comprised primarily of InfoObjects generated by the Load stage.
  • Lets you create InfoPackages to load data from the Load stage, including load requests initiated by the stage. (You can schedule the load using SAP BW.)
  • Supports the use of job parameters for the source system and connection properties of the stage.
  • Is integrated with the InfoPackage third party selections for the SAP BW user interface to allow the display of InfoSphere DataStage job parameters and possible values.
  • Supports the creation of third party Source Systems.
  • Integrates with the SAP BW GUI InfoPackage monitor to display the InfoSphere DataStage job log from within the SAP BW GUI.
  • Supports data streaming directly to SAP BW.
  • Provides multithreaded RFC Servers to support simultaneous load requests.
  • Supports loading of master data hierarchies.
  • Supports SAP load-balancing capabilities
  • Provides the InfoSphere DataStage Administrator for SAP utility to manage:
    • RFC Servers
    • RFC Server logs
    • SAP BW connection configuration
    • Source System configurations
  • Supports NLS (National Language Support). For information, see National Language Support.
  • Server jobs provide the ability to Reset and Validate a job. The InfoSphere DataStage Director Reset selection might resolve potential problematic job issues.
  • RESET:
    • Server: Checks for previously existing intermediary files
    • Deletes previously existing intermediary files
    • InfoSphere DataStage Director log updated by runtime
  • The InfoSphere DataStage Director Validate selection confirms job properties and BW connectivity without running the job.
  • VALIDATE:
    • Server: Checks Job Open Sequence
    • Checks all job properties
    • Checks BW connections
    • Checks Job Termination Sequence
    • InfoSphere DataStage Director log updated by runtime