Data Services within the SAP BI staging process

...Previous

Include all the InfoObjects created earlier in this InfoSource. 

Save and Activate InfoSource 

Click Yes, for activating all the independent transfer programs. 

You would see logs on the screen as shown below. Go back. 

Now, create Transfer Rules for the newly created InfoSource. 

Click Yes for assigning the DataSource to InfoSource. 

Save and Activate the InfoSource. 

Go back and you would see the subtree similar to following. 

To import the SAP BI structures, open the Datastore tab strip in the Object Library. Search for the Datastore that you have created for the SAP BI system as target (in our caseBW_PoC_Target_Datastore). Position the cursor on the Datastore name and choose Open from the context menu. Depending on the structures you want to use, expand the Master InfoSources or Transaction InfoSources tree. 

Find your InfoSource, and open its subtree. Position the cursor on the DataSource name, and use the option Import from the context menu. 

Afterwards, the DataSource will be available in the Object Library for your SAP BI system. 

Open the workflow, you have created in the previous section. Open the Datastore tab strip in the Object Library. Search for the Datastore that you have created for the SAP BI system as target (in our case BW_PoC_Target_Datastore). Drag the structure to the canvas you want to load the data in the SAP BI system to. Connect the existing Validation Transform with the new target.

Double click this new target to open the Target Table Editor as shown below. Go to Options tab and select Column Comparison = Compare by position. 

This is done so that even if column names do not match (InfoObject names cannot be more that 9 characters), we can still go ahead and carry out the data movement.  

Validate your DataFlow. 

Click here to continue...