Installation Guide for SAP Data Source
OracleAS Portal Integration Solutions
OracleAS Data Source Plugin for OmniPortlet for SAP - Installation Instructions
| Last Updated: |
May 2005 |
| Status: |
Beta |
Contents
Introduction
Requirements
Contents of sap.zip
Deploying the OracleAS Data Source Plugin for OmniPortlet for SAP
Installing
the
OracleAS Data Source Plugin for OmniPortlet for SAP files
Installing the JCo
library files
Testing the deployment
Publishing the OracleAS Data Source Plugin for OmniPortlet for SAP
Creating the
External Application
Registering the
OracleAS Data Source Plugin for OmniPortlet for SAP Provider
Adding
the OracleAS Data Source Plugin for OmniPortlet for SAP Provider's OmniPortlet to a Page
Introduction
The OracleAS Data Source Plugin for OmniPortlet for SAP is a plugin data source for OmniPortlet (more details
on OmniPortlet).
The OracleAS Data Source Plugin for OmniPortlet for SAP allows a user to build SAP portlets declaratively, in a
very
short time without writing any code, leveraging Single-Sign-On and many of the OmniPortlet features like –
Filteration, Parameters and Events, Layouts & Views.
The OracleAS Data Source Plugin for OmniPortlet for SAP plugin for OmniPortlet makes it fast and easy to
create,
customize and deploy robust portlets that leverage existing SAP
business processes
and data. Using the OracleAS Data Source Plugin for OmniPortlet for SAP, SAP portlet developers can
declaratively
The OracleAS Data Source Plugin for OmniPortlet for SAP leverages SAP Java
Connector (JCo) to provide connectivity with the SAP R/3
server. This document contains installation and configuration
information for the OracleAS Data Source Plugin for OmniPortlet for SAP.
Although this document
only talks about the installation of OracleAS Data Source Plugin for OmniPortlet for SAP on Windows, Linux
and Solaris platforms; it can be deployed on any other platform by
getting the corresponding JCo libraries for that platform.
"NOTE: The OracleAS Data Source Plugin for Omniportlet for SAP is a sample released for test, evaluation, and education purposes. It is not supported through formal Oracle Support mechanisms. We are, however, very interested in receiving your feedback. Please post any suggestions, questions, or issues to the 'Portal - Portal Development Kit' Discussion Forum on OTN. We will respond as quickly as possible."
Requirements
- PDK Release 2 (9.0.4.0.2 and later)
- OracleAS Portal 9.0.2 or above
- SAP R/3 Release 40B and upwards
- SAP Java Connector API (sapjco.jar
version
2.0.2 or later) available at http://service.sap.com.
Following are the details about SAP Java Connector:
- Title: SAP Java Connector
- Implementation-Title: com.sap.mw.jco
- Implementation-Version: 20020619.0430
- Implementation-Vendor-Id: com.sap
- Implementation-Vendor: SAP AG, Walldorf
- Supported Platforms:
- Microsoft Windows NT 4.0 Service Pack 4 or later, Windows
2000
- Linux Kernel 2.2.14 or later
- Sun Solaris 2.8 or later
- IBM AIX 4.3 or later
- HP-UX 11.0 or later
- Compaq Tru64 5.0 or later
- OS/390
- librfc32.dll and sapjcorfc.dll
for Windows Platform.
- librfccm.so and libsapjcorfc.so
for Linux and Solaris Platforms.
Contents of sap.zip
You can download the OracleAS Data Source Plugin for OmniPortlet for SAP from the Portal
Integration Solutions page on OTN Portal Center.
To deploy the OracleAS Data Source Plugin for OmniPortlet for SAP, first unzip the sapds.zip file into any temporary
directory,
for example C:\TEMP (On Windows) (we will now refer to this directory
as
$unzip_directory). Unzipping the sapds.zip to
the $unzip_directory creates the following directory structure:
$unzip_directory
- sapds.zip
- installation.sapds.html
- release.notes.sapds.html
- version file
Deploying the OracleAS Data Source Plugin for OmniPortlet for SAP
Before deploying the OracleAS Data Source Plugin for OmniPortlet for SAP provider,
you should have successfully deployed the portalTools
Application. portalTools is part of the PDK
download. Please download the pdksoftware.zip
file from OTN and follow the
instructions for installing portalTools
from the document installing.portalTools.html, which can
be found under the pdk/portalTools directory when you
unzip pdksoftware.zip.
Installing the
OracleAS Data Source Plugin for OmniPortlet for SAP
In order to deploy the OracleAS Data Source Plugin for OmniPortlet for SAP, please copy the sapds.zip
file from $unzip_directory to $IAS_HOME/applications/portalTools/omniPortlet/
which contains the deployed portalTools application. A successful unzip
at
the target location $IAS_HOME/applications/portalTools/omniPortlet/
should have created the following directory structure,
$IAS_HOME/applications/portalTools/omniPortlet/htdocs/plugins/datasources/sap/{all
JSP's & images}
$IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/deployment/sap.properties
$IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/lib/sapds.jar
$IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/lib/intshare.jar
$IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/plugins/datasources/sap/datasource.xml
$IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/providers/sap/provider.xml
Now open the web.xml file from $IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/
and add the following entries, just above the closing
tag </web-app>
<servlet>
<servlet-name>ControllerServlet</servlet-name>
<servlet-class>oracle.webdb.reformlet.plugin.datasource.sap.uicontroller.Controller</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>ControllerServlet</servlet-name>
<url-pattern>/servlet/Controller</url-pattern>
</servlet-mapping>
<servlet>
<servlet-name>LoginServlet</servlet-name>
<servlet-class>oracle.webdb.reformlet.plugin.datasource.sap.LoginServlet</servlet-class>
</servlet>
<servlet-mapping>
<servlet-name>LoginServlet</servlet-name>
<url-pattern>/servlet/login</url-pattern>
</servlet-mapping>
Save the web.xml file.
Installing the JCo
library files
In order to successfully deploy the OracleAS Data Source Plugin for OmniPortlet for SAP, you will need to
put the appropriate JCo library files (for specific platform) in the
location described below.
You can download the required JCo libraries, for the target platform
from
http://service.sap.com.
On Windows Platform
Put the sapjco.jar in $IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/lib.
Copy sapjcorfc.dll and librfc32.dll
at WINNT/system32 directory.
On Linux and Solaris Platform
Put the sapjco.jar in $IAS_HOME/applications/portalTools/omniPortlet/WEB-INF/lib.Put
libsapjcorfc.so
and librfccm.so
under your $LD_LIBRARY_PATH.
Note: You can find $LD_LIBRARY_PATH by executing the
command,
echo
$LD_LIBRARY_PATH
Put libsapjcorfc.so
and librfccm.so
in one of the directories mentioned in the $LD_LIBRARY_PATH.
If LD_LIBRARY_PATH
is not already set, use the command setenv
LD_LIBRARY_PATH
$HOME/<ld_library_directory>
Testing the Deployment
The SAP Portlets are now deployed. To test the deployment, access the
provider's test page at the following URL:
http://your_oc4j_hostname:port/portalTools/omniPortlet/providers/sap
Publishing the OracleAS Data Source Plugin for OmniPortlet for SAP
Creating the
External Application
OracleAS Data Source Plugin for OmniPortlet for SAP leverages OracleAS Portal External Application feature
to provide Single-Sign-On (SSO) to the SAP R/3 server.
- Log on to OracleAS Portal as an OracleAS Portal
Administrator. Go to the Administer
tab of the OracleAS Portal Builder.
In the SSO Server Administration portlet, click
Administer
External
Applications.
- Click on Add External Application. In the External
Application Login and Authentication
Method sections, enter the
following:
- Application Name: SAPExternalApp
- Login URL: http://your_oc4j_hostname:port/portalTools/omniPortlet/servlet/login
- User Name/ID Field Name: Username
- Password Field Name: Password
- Type of Authentication Used: Select POST
In the additional field section, add the following:
| Field Name |
Field
Value |
Display
to
User |
| clientId |
<Mandatory e.g. 700> |
Check this box |
| language |
<Mandatory e.g. EN> |
Check this box |
| systemId |
<Mandatory> |
Uncheck this box |
| hostname |
<Mandatory> |
Uncheck this box |
| connectionPoolSize |
<Mandatory e.g. 5> |
Uncheck this box |
Note:
1) A connection pool is created per OracleAS Portal user. The
connectionPoolSize indicates the number of parallel requests that would
be serviced for each OracleAS Portal user. Normally,
you should set this value to the maximum
number of SAP portlets that would be added on an OracleAS Portal page.
2) language specifies the locale, with which the user connects to SAP
R/3 server. If you were to change the locale, you should make the
corresponding change in the language value. Please refer to the OracleAS Data Source Plugin for OmniPortlet for SAP Release Notes for further details.
- Click OK.
- Click on the link for your new SAPExternalApp
application and enter the SAP Username and Password. The check box for Remember
My Login Information... must be checked.
- If successful, you should get the message like "You have
been successfully authenticated with the target SAP R/3 server".
At this instance, your valid SAP R/3 credentials have been safely
stored on the Oracle Internet Directory (OID) and you can leverage the
OracleAS Single
Sign On to login to the target SAP R/3 server.
- If unsuccessful, you will get an appropriate error message
highlighting the cause of failure. Go back to the External Application
and pass the right credentials. Unless, your credentials get validated,
you will not be able to get connectivity to
Registering
the OracleAS Data Source Plugin for OmniPortlet for SAP Provider
- Login to OracleAS Portal using an account that has build privileges. If your home page is not the Build/Administer
page, click on the Builder link in the
top right corner of the screen. Click on the Build
tab if that is not the active tab.
- Under the Build tab (on OracleAS
Portal Home Page), click on Register Portlet
Provider within the portlet called Providers.
- Fill out provider information for the OracleAS Data Source Plugin for OmniPortlet for SAP Provider:
- Name: SAPDataSourceProvider
- Display Name: OracleAS Data Source Plugin for OmniPortlet for SAP Provider
- Timeout: 100
- Timeout Message: OracleAS Data Source Plugin for OmniPortlet for SAP
Provider
Timed Out
- Implementation Style: Web
- Click on the Next button to enter the Web Provider
specific information
- Enter the Web Provider location
- URL: http://your_oc4j_hostname:port/portalTools/omniPortlet/providers/sap
- Scroll down to the User/Session Information section and
specify the login frequency as Once Per
Session.
- Select the radio button labeled The
user's
identity needs to be mapped to a different name....
In
the External
Application ID field, select the ID corresponding to SAPExternalApp
application you created in the previous step.
- Click on the Finish button to complete the
registration
Note: When registering a new provider with OracleAS Portal, only
the user who registered the provider has privileges to see the
provider/portlets. If necessary, go to the Folder with the name of the
provider within the Portlet
Repository content area and update the provider privileges as required.
Adding
the OracleAS Data Source Plugin for OmniPortlet for SAP Provider's OmniPortlet to a Page
Add the OmniPortlet instance of the registered OracleAS Data Source Plugin for OmniPortlet for SAP Provider
to an OracleAS Portal page. You are now ready to define this
OmniPortlet instance
to use the OracleAS Data Source Plugin for OmniPortlet for SAP. Please go through this demonstration
that walks you through the define experience of OracleAS Data Source Plugin for OmniPortlet for SAP.
Note:After adding the OmniPortlet instance to an OracleAS
Portal page, if you are logged on as a user other than the OracleAS
Portal administrator, you will be asked to update the login
information for the External Application. Click on the Update
Login Information link and enter your SAP R/3 user
credentials: Username,Password,ClientId and Language.
Once the credentials have been
validated, you can start defining the OmniPortlet instance to use the
OracleAS Data Source Plugin for OmniPortlet for SAP.
Trademarks
Oracle and the Oracle logo are trademarks or registered trademarks of Oracle Corporation in the United States and other countries.
All other names are trademarks and/or registered trademarks of their respective owners.
|
Bookmark
