Linking BW to Enterprise Portal (EP)
Summary
Step-by-step list, explaining how to link a BW system to an EP system. (Note: Those are the personal notes an EP novice, they should not be used as a reference!)
Linking a BW System to the Enterprise Portal (EP6.0):
In the following article, I want to share my experience in linking a BW System (release BW3.5) to an Enterprise Portal (release BW6.0SP2). Before diving into the subject matter, I want to note that I am fairly technically experienced in the BW system, however so far only had very limited exposure to the EP, or to J2EE platforms in general. Given this, first I was ready to hand over the task of linking the two systems to an experienced colleague. On a second thought, however, I said to myself "heck, lets give it a try".
After browsing through the documentation and some system settings, after about 2 hours I had successfully built (and tested) the connection (again, with NO prior experience in this area at all)! (Ok, I admit, 5 minutes counseling by an EP expert probably had helped as well).
[Before I go into details, just a warning: The steps before worked for me. However results may vary, things depend partially on your local IT infrastructure. Also, some of my statements below *could* be incorrect. For any serious activities, you should make sure to either receive the proper training, or to consult with an expert in the respective area.]
Those were the steps I had to take (btw, I had super user rights on the EP):
- Once logged into the EP, choose "System Administration", then "System Configuration", then "System".
- You will see a screen "System Landscape Editor", and on the left to it "Portal Content". Right-Click on "Portal Content", and choose New >> System".
- The System Wizard comes up. Choose "SAP_R3_LoadBalacing" (if your system is load balanced, like in my case). Click "next".
- Enter the following:
System Name (here I choose the 3 digit system name from the logon, something like BW1?)
System ID (here I choose the logical system ID, like BW1CLNTT003; you can get this e.g. from table T000 in the BW system)
System ID Prefex (a prefix to find and group your settings, e.g. BW)
Then save as system. Click "next".
- Choose "Property Category = Connector", and maintain the following fields:
Application Host (the address of the host; you can get this e.g. from the BW WAD from a web query URL string; it?s what comes after http:// and before ?:[port]"; something like ?usbw0101.xxx.com")
Logical System ID (you can get from table T000 in the BW system, something like "BW1CLNT003")
SAP Client (BW client name)
SAP System Name (here I entered the 3 letter system name, like "BW1")
SAP System Number (you get this e.g. from the BW logon properties)
Server Port (this again you get e.g. from the query URL string mentioned above, it?s the number which comes after the Application host; e.g. ?8100?)
System Template Name (here I used again the logical system ID from above)
System Type ("SAP_BW", of course)
- Choose "Property Category = WAS", and maintain the following fields:
WAS description (same as System Name above, e.g. "BW1")
WAS host name (same as application host above, but together with port number from above, i.e. something like "usbw0101.xxx.com:8100")
WAS path "/sap/bw/bex"
WAS protocol ("http")
- Choose "Property Category = User Management", and maintain the following:
Logon Method ("SAPLOGONTICKET").
User mapping fields ("{003,800}Client;Language")
User Mapping Type ("admin, user")
Save all your settings.
- Still from the same screen, choose "System Aliases". Create and save a new "System Alias". Basically, I picked the logical system ID "BW1CLNT003" as system alias, and saved this.
- Almost finished: As a next step, I had to perform what?s called ?user mapping? (so the EP can talk to the BW on behalf of a specific user). I went to "User Administration", the "User Mapping". I searched (in this case) for my user in "Users", then (under "Logon Data for System") selected the BW system, and maintained the login settings.
Final Step: Now you are ready to test the system connection! For this purpose, go to "System Administration", then "Support", from here to "SAP Application". Under "Tool" select "BWReport", and push ?Run?. Select your BW system, and a BEx Web Application Query String (you can use the string from the WAD URL above, basically the piece which starts with "cmd"; e.g. like? cmd=ldoc&TEMPLATE_ID=LSTEMP?). Execute, and you should see the query results right in your Portal!
|