Data Services within the SAP BI staging process


PoC – Loading unstructured data from Flat files into SAP BI using BusinessObjects Data Services 

Let us take a sample tab delimited flat file as shown below. (Note - Sample data is placed in an excel file only for understanding purpose. In actual PoC we will be using a text file) 


For the sample flat file used here, click here. 

Define the SAP BI system as Datastore in Data Services  

Before we start designing a job for our PoC, let us create a datastore for SAP BI system. 

  1. Open the BusinessObjects Data Services Designer.
  2. In the Local Object Library, select the Datastore tab.
  3. Right click and select New to create new Datastore as shown below

  1. Type in datastore name as shown below.
  2. Select SAP BW Target as the Datastore type. This is because we want to load data into SAP BI and hence SAP BI is the target.
  3. Enter location/IP address of the SAP BI system server
  4. Enter your user name and password for the SAP BI
  5. Under Advanced section, enter Client and System Number. ( You can find system number, application server details from SAP Logon Pad > Change Item)
  6. In our example (refer screenshot 4), enter ‘/H/’ as the router string.
  7. Hit OK.

  1. The new datastore BW_PoC_Target_Datastore is now available under Local Object Library as shown below.

Defining new Flat File format for our sample data 

  1. Open the BusinessObjects Data Services Designer.
  2. In the Local Object Library, select the Formats tab
  3. Right click on Flat Files format and select New.

  1. You will see File Format Editor window
  1. Select/Enter the data as given below
    1. Type – Delimited
    2. Name – PoC_File_Format
    3. Root directory – Path where the sample flat file is stored (In our case it is - C:\Documents and Settings\164600\My Documents\BOBJ Data Services\BOBJ Data Services\Reference Material\PoC)
    4. File name – In our case it is PoC1.txt. You would see a prompt to overwrite the current schema.

      Hit Yes. Now, you would see your sample data in the editor window. Note that Designer automatically assigned appropriate data types based on the input data.

    1. Under Delimiters, select Column – Tab
    1. Click Save & Close

PoC_File_Format is now available under the Flat Files tree in the Local Object Library as shown below.

Click here to continue...

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image