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