Data Services within the SAP BI staging process

...Previous

Since the loading process has to be initiated by the SAP BI system, we have to create a batch file for the execution of the Job in Data Services. This batch file can subsequently be called by an InfoPackage in the SAP BI system. 

Open the Data Services Management Console by choosing the corresponding menu entry from the Tools menu.  

Log in with your user credentials. In the Management Console navigate to the Administrator, and open your repository (or All Repositories) of the Batch folder.  

Switch to the Batch Job Configuration tab strip and find your Job you want to schedule. Choose the option Export Execution Command.  

Provide a File Name for the batch file. Leave the other settings on the default values and press the Export button.

Note

Since the maximum length of the file name entry field in the InfoPackage is limited to 44 characters, your file name entered must not exceed 40 characters (44 characters minus 4 characters for the extension .bat)  

Screen would refresh confirming the successful export. 

In our case following two files gets created after the export under C:\temp folder. 

Before you switch to the SAP BI system, check that the RFC server is still running.  

Switch to the SAP BI system you want to load the data to. Open the Data Warehousing Workbench and find your InfoSource / DataSource. Create an InfoPackage for the DataSource.  

Switch to the 3rd Party Selection tabstrip. Press the Refresh Sel. Fields button to display the input fields.  

Click here to continue...