Hi Mahesh,
Few questions though...R/3 to BI via SAP??????? Why on earth would you want to do that? BI has its own extractor - SAP Connect - Which does this for you...
Oh and by the way, i did solve the whole solution end to end to Integrate XI 3 to BI 7 and just to inform all those out there, it's NOT as straight forward as the HowTo guides indicate.
There are alot of things to be done:
a. Create the WebService Datasource in BW
b. Create an InfoPackage on the WebService DataSource
c. Create a Real-Time DTP
d. Set up the proxy according to the HowTo guide
e. Assign a Daemon to the InfoPackage
f. Assign the DTP to the Daemon
Now here it starts becommong interesting. The InfoPackage has a setting to close the request after 1 hour is passed, this doesn't happen no matter what you do. The Request will close after 100k records, and honestly...that is not Real-Time using a push from XI if you ask me...
As for the Daemon, it can be set to gather info from the Delta Queue every minute, but will not close the request once it has the data, but is dependant on the InfoPackage setting that says that it will close after 100k records, because as said, the 1 hr option is NOT working. This is apparantly fixed in Service Release 14.
So for the Grand Finale, you need to use some of your ABAP skills that you've accumulated over the past years and write 2 small little programs that call 2 different function modules which does the following:
a. It stops the Daemon - this automatically closes the request and the data
is then automatically uploaded via the DTP to the data target which
is normally a DSO seeing that a Cube cannot be used as a Data Target in
a Real-Time Scenario. VERY NB!!!! - YOU MUST ACTIVATE THE
DSO BEFORE you can load data via the Daemon again.
b. The other function module will then start the Daemon again.
Daemon beheviour - or as i call it Demon behaviour after the struggle - is simple in the fact that once the Daemon is active it generates an empty request that lies and waits for data. Once the Daemon is closed it releases that request. If you restart it, it will generate a new request.
Just a pitty i am not allowed to score myself...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.