Migration guide for Legacy SAP BW Stage to CP4D SAP BW Extract Connector

Overview of SAP BW connector

Pre-requisites

Migrating the SAP BW Extract Job

Importing and executing the migrated job into canvas

SAP BW migrated job connection and runtime check

Overview of SAP BW connector

This document guides the user to perform migration from legacy SAP BW Extract stage to SAP BW Extract connector in CP4D environment.

Pre-requisites

Correct ISX file must be created by the user before importing this to CP4D environment. Users need to make sure to create the proper isx based on scenario to be checked.

Migrating the SAP BW Extract job

Create an ISX file from a compliable and runnable SAP BW Extract job created in DataStage Designer Client. Use ISTOOL for creation and exporting of ISX file. For detailed instructions on the steps involved, refer.
Export command for InfoSphere DataStage and QualityStage assets and How to use ISTOOL for EXPORT IMPORT Information Server Components.

Note: Make sure that the ISX file export includes all dependencies, such as parameter sets and table definitions.

Create the isx file from the legacy:
Open command prompt and go to: cd C:\IBM\InformationServer\Clients\istools\cli
Here’s a sample command:
istool export -dom <Hostname> -u <username> -p <password> -ar /<Jobname.isx> -ds '<Hostname>/<project>/<folder><jobname.pjb'>

If there is any environment variable or parameter or parameter set, then use the below command:
istool export -dom <Hostname> -u <username> -p <password> -ar /<Jobname.isx>-u -p -ar /<Jobname.isx> -ds ' ///<jobname.pjb'> -ds '<Hostname>/<project>/<folder><jobname.pjb'> -includedependent'

Import the ISX file in CP4D cluster:

1. Open an existing project or create a new Project in the CP4D canvas. (Refer screenshot below for existing project).
   

   
   

2. Click on “New asset”. 
   
3. Click on “Transform and integrate data”.
   
   
   
4. Click on “Local file”.
   
5. Click on “Browse”, select isx file and then click on “open”. 
   
6. Click on “Create”.
   
   
   
   
   
    

1. Click on project for navigating to project window.
   
   
   
2. Open “connection” and click on “Test connection”. 
   
   
   
    
3. Open SAP BW extract migrated job flow.
   
   
   
   
   
   
   
   
   
4. Compile job flow.
   
5. Run job flow.
   
   
   
   
   
   
   
   
   
   
   
6. Output file.