Preventive Service Planning
Abstract
This technote describes the feature comparison & migration scenarios of SAP BW Pack Open Hub Extract stage versus CP4D SAP BW Extract connector.
Content
Disclaimer
CP4D SAP BW Extract connector is a new connector dedicated to Cloud Pak for Data platform.
This document guides the user to perform migration from legacy SAP BW Open Hub Extract Stage to SAP BW Extract Connector in CP4D environment, if migration is possible. Only jobs compatible with the new SCAPI BW Connector features are subject for the potential automated migration.
New Cloud Pak for Data SAP BW Extract connector features and limitations
- Cloud Pak for Data connector uses ‘Cloud Pak for Data Connections UI’ to manage (create/modify/delete) SAP connection objects (no dedicated Admin UI available)
- Cloud Pak for Data SAP BW connector only supports PUSH mechanism. PULL mechanism is not supported due to intermittent BW RFC server.
- Cloud Pak for Data SAP BW Extract connector supports Columns/Metadata through Asset Browser.
- Both sequential and parallel execution modes are supported
Migration Applicability Scenarios
- Automated migration process has been created to migrate the SAP BW stage jobs to SAP BW Extract connector. Users need to create the isx of older job design and import the same in Cloud Pak for Data environment.
- Use ISTOOL for creating and exporting ISX files. For detailed instructions on the steps involved, refer
Export command for InfoSphere DataStage and QualityStage assests and How to use ISTOOL for EXPORT IMPORT Information Server Components - Note: Make sure that the ISX file export includes all dependencies if required, such as parameter sets and table definitions.
Here's a sample command:
istool export -dom DELVM04S02:9443 -u isadmin -p isadmin -ar /sap_bw_extract/BW_Extract_SNC_Load_Balancing_001.isx -ds 'DELVM04S02/dstage1/Jobs/BW_Legacy_CP4D_Migration/BW_Extract_SNC_Load_Balancing_016.pjb'
- If the IDoc Extract/Load Stage job is designed to use Parameter or Parameter Sets in job, ensure that you use the switch -includedependent in the command line tool.
- istool export -dom DELVM04S02:9443 -u isadmin -p isadmin -ar /sap_bw_extract/BW_Extract_SNC_Load_Balancing_001.isx -ds 'DELVM04S02/dstage1/Jobs/BW_Legacy_CP4D_Migration/BW_Extract_SNC_Load_Balancing_016.pjb -includedependent''
Feature comparison
| Feature Group | Feature / Properties | SAP BW Open Hub Extract Stage Support | SAP BW Extract Support | Feature Migration Feasibility |
|---|---|---|---|---|
| Source System | Attach Source System | You can attach source system from list of already existing source systems in SAP | List of available source system is not present. Users can provide the source system name for “Source System” stage property. | Legacy stage selected source system will display for “Source System” stage property |
| New Source System | Creates new source system within SAP | Connector runtime will create source system with given name in “Source System” stage property. Source System name can be auto-generated using property “Automatic creation of source system name”. | Legacy stage created source system will display for “Source System” stage property | |
| Remove Source System | Remove the selected source system from available list of source system in “DataStage Administrator for SAP BW”, doesn’t delete the source system from SAP | After successful data extraction, connector runtime will delete the source system. | Not Applicable | |
| Select Source System | From the list of attached source systems, select one | No list will be displayed for existing source system. You can only provide the source system name in stage properties | Legacy stage selected source system will be available after migration | |
| Clear Source System | Clear the currently selected Source System in the job design. | This feature is more relevant in legacy, where source system property in “BW Open Hub extract stage” is non-editable and value is coming from “DataStage Administrator for SAP BW”. | Not Applicable | |
| Source System properties | Displays Source System Properties | This feature is more relevant in legacy, as source system creation happens in “DataStage Administrator for SAP BW”. | Not Applicable | |
| Process Chain | Select Process Chain | Select a Process chain from the list of available Process chains in SAP. | List of Process Chain names will be automatically populated in the stage properties “Process Chain” based on the selected Open Hub Destination during new flow creation. | Legacy stage selected process chain will display for “Process Chain” stage properties. |
| Filter support for Process chain | Users can search the Process chain by name | List of Process Chain names will be automatically populated in the stage properties “Process Chain” based on the selected Open Hub Destination. No Filter option is available for Process Chain list. | Not Applicable | |
| Open Hub Destination | Select Open Hub Destination | Select the Open Hub Destination from the list of available OHDs in SAP. | List of available OHDs is available for new Jobs. | Legacy stage selected OHD will display for “Open Hub Destination” stage properties. |
| Filter support for Open Hub Destination | Users can search the OHD by name | Users can search the OHD by name in displayed list of available OHDs for new jobs. | Not Applicable | |
| Skip Technical Keys | Skip Technical Keys | Un-Checked — Add technical keys in column metadata Checked — Remove technical keys from column metadata | Un-Checked — Add technical keys in column metadata Checked — Remove technical keys from column metadata | “Skip Technical Key” stage property will be checked/un-checked as per legacy stage selection. Un-Checked — Column metadata contains technical keys Checked — Column metadata doesn’t contain technical keys |
| Update BW | Update BW | Updates 3rd party parameters in SAP i.e., Source System, Process chain and Job name. | Connector runtime will update the 3rd party parameter on SAP. | Not Applicable |
| Monitor RFC Server Logs | Monitor RFC | Display BW RFC Server logs in “DataStage Administrator for SAP BW”. | Connector runtime will initiate intermittent RFC Server; logs will display as Job logs. | Not Applicable |
| BW Table Name | BW Table Name | Display the underlying table name for the Open Hub Destination. | Not Supported | Not Supported |
| Column Metadata | Columns | Displays column metadata for OHD underlying table. | Displays column metadata for OHD underlying table. | Legacy job column metadata will be present under columns. |
| Synchronize Columns | Synchronize and update the column metadata with SAP. | Not Supported | Not Applicable | |
| Validate Columns | Validate the column metadata with SAP. | Not Supported | Not Applicable |
[{"Type":"MASTER","Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSHGYS","label":"IBM Cloud Pak for Data"},"ARM Category":[{"code":"a8m3p000000UoR7AAK","label":"Administration-\u003EConnections"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"5.2.0"}]
Was this topic helpful?
Document Information
Modified date:
12 November 2025
UID
ibm17250695