|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
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
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'.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards