Beginner’s Guide to Real Time Data Access via Web Services in SAP NW-BI


Here, as illustrated, we name the data source using a name, describe its Source system as XML_DATA & it’s to be noted that we are using a data source which utilizes 'Transaction Data' perfect for reporting purposes. XML_DATA is the source system, as XML is very light weight & is currently used widely in Web Services. Here, in the 'Extraction' field, we have an adapter option, where we must choose to use a push service. So we must choose 'Web Service (Push)'. As for as extraction is concerned for this data source it’s never a problem specifying the file names, header rows, columns to be ignored etc. When using Web service its tad simpler as compared to 'Load Data from Flat Files' following these issues. But by any means, XML can handle only limited data & has its own pros & cons.  This is the next tab, ‘Proposal’ tab where we must specify the fields for use.

So we need to copy these from the DSO structure of previous source DSO, which is DS_SLS. Now that we have copied, they are pasted as in order. Save & Activate. Now, Save and activate the new structure. There's a dialog box displaying an information 'R3TR generated changes possible'. Now that the Data source has been successfully created & activated, we can refresh & find if it’s activated or not; after a refresh, we can notice the 'Active' Version of the Data source.

Creation of IP: We now create an IP. Right click DS & choose option "Create Info Package". Enter a description for this IP & Click Save. Click 'Yes'

Finally the Info package has been created. We can notice the technical name of the IP starts with "ZPAK......” Now, we need to migrate to the reach the Web administration. From here we can directly go to 'Web Service Administration' or use TCODE WSADMIN. But for now we move on to create the entire data flow structure, further which we can transfer data from portal to Info providers (like DSO) via IP & DTP

This is an optional step. Go to WSADMIN to view the URL, Web service Key, Release Text, WS Definition etc. Also don’t assign IP at this stage. Creation of Transformation: Right click the DSO & choose the option "Create Transformation". This will now create a transformation to map source(s) & target(s). Create Transformation: This has the Source & Targets. Here the source object is the Data source (DS_XML_CSK) & the source system is XML_DATA. Now, the target object is of type "Data Source Object" (DSO SOAP; Technical Name: C_DSO_SO). In the transformation level, we have mappings between the source Data source & the target DSO. Creation of DTP: At this step we create a DTP. Right click on & choose the option "Create Data Transfer Process..."

Fig.1.22 - As earlier, we need to choose setting of the options - DTP Type: "DTP for Real Time Acquisition" & Source is Data source (DS_XML_CSK); Target is DSO (DSO SOAP; Technical Name: C_DSO_SO.  Notice the 'Execute' option is disabled. The DTP is now in 'Modified' state, so it must be activated. Now, we can notice the Version is now 'Active' & Mode: 'Processing Mode for Real-Time Data Package'. Even after Activation, the 'Execute' option would not be enabled, because it must be handled by a daemon. So, we go to RSRDA, where we create a daemon.

Create a daemon in RSRDA, using key F5 or clicking 'Daemon' command button. Now, enter the Daemon #, Short Description and Interval Period [1 min]. After this click on 'Save'. We can notice the nodes which are all daemons. Here we our Data sources (DS_XML.... etc) under the category 'Unassigned Nodes’. Now right click the corresponding DS & choose an option to 'Assign Daemon' to a particular daemon 'node'.

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