Jedox Worksheet-Server Business
Application - Technical Description and Configuration Information
Purpose
This process describes how to
implement access to Worksheet-Server in SAP Enterprise Portal 6.0 or 7.0.
Supported Roles
The business package
comes without any predefined role concept. Applications developed with
Worksheet-Server are suitable for any possible ASP portal role. Typical roles
could be members of finance and controlling department.
Availability
Available for EP 6.0 and EP 7.0
As a Back-End: Worksheet-Server 2.0
This business package is available in English
Recommended browser: Microsoft Internet Explorer 5.5 and above.
Prerequisites
-
Running installation of Worksheet-Server 2.0 or greater with SAP EP functionality:
-
Make sure that the Enterprise Portal server and your Worksheet-Server are running in the same DNS domain. Otherwise cookies issued by the Portal server will not be transferred to Worksheet-Server by the client browser.
-
Add user with the same username to both Enterprise Portal and Worksheet-Server.
-
Download userauth.zip, unpack and copy it to the "bin" application directory on the Worksheet-Server. Use text editor to adjust path to "verify.pse" if necessary.
o
Download SAP security library(sapsecu.dll) and Ticket
Toolkit(wpsso_v3.dll) from SDN and copy them into system path of your
Worksheet-Server
In order to verify a Single Sign-On
ticket sent with a browser request, you need the SAP security library
sapsecu.dll which can be downloaded from SAP‘s
Service Marketplace (http://service.sap.com/swcenter, needs a separate
partner/customer User). Navigate in the right pane to Download -> SAP
Cryptographic Software to get the library. Put that file in a directory
accessible via your system variable %PATH%, e.g. the system32 subdirectory of
your OS. The same applies for Ticket Toolkit‘s wpsso_v3.dll.
o
Export the portal .pse file to
Worksheet-Server extensions directory
Log on to your Enterprise Portal as
a member of the system administration group. Navigate to System Administration
-> System Configuration. In the detailed navigation choose Keystore Administration. On the Content tab the Portals.
Choose the Download verify.pse file button to
download a .zip file containing the portals .pse
file. Extract and rename the .pse file and place it
in an extensions subdirectory of your Worksheet-Server
Process Flow
Install package: Download the Worksheet-Server Business package from the Jedox website. Log on to your Enterprise Portal as a member of the system administration group and deploy all files to your portal installation with Import function (System Administration/Import)
-
Customize portal: navigate to Content Administration/Portal Content/Content Provided by Other Vendors/End User Content/Jedox: Worksheet-Server. Select Jedox Worksheet-Server iView object and open it. In Property Category combo box choose Content – Generic Launcher. Navigate to URL template property. You will notice the following default value set:
http://ws.jedox.com/folders/kd305016355/quickdemo/run.html?defuser=dummy&defpass=dummy&silent=2&extcss=<LAF.StylesheetUrl>
Make sure you adjust this URL template value to
match your installation:
|
Parameter |
Value(s) |
Description |
|
Type of connection:// |
<http>:// or <https>:// |
Specify the type of connection you wish your EP clients are going to
use for this iVew. Options are normal(http) or secure(https). |
|
Worksheet-Server DNS Name:Port/folders/ |
<server>:<port>/folders/ |
The DNS Name and the port on which Worksheet-Server is running. If
port is 80 or 433 then if http or https is used respectively, double dot and
port number can be omitted. Example: ws.jedox.com:8080/folders/ |
|
Directory/ |
kd<directory>/ |
The name of the Worksheet-Server‘s directory where the application is
going to be executed. Example: 305016355/ |
|
Application/ |
<application>/ |
The name of the WorkSheet Application which
is going to be run. Example: quickdemo |
|
Worksheet-Server specific suffix |
run.html?defuser=dummy _&defpass=dummy&silent=2 _&extcss=<LAF.StylesheetUrl> |
The last GET parameter – extcss contains variable
that will be evaluated before sent to user and which contains full path to
EP‘s theme css. This complete suffix is mandatory and should be left like specified in
the package. The purpose of this is to enable single-sign-on from and theme
look and feel as in Enterprise Portal. |
The end URL
template value form for HTTP should look like this:
<http>://<server>:<port>/folders/kd<directory>/<application>/run.html?defuser=dummy&defpass=dummy&silent=2&extcss=<LAF.StylesheetUrl>
Or for
HTTPS:
<https>://<server>:<port>/folders/kd<directory>/<application>/run.html?defuser=dummy&defpass=dummy&silent=2&extcss=<LAF.StylesheetUrl>
-
Uninstall procedure:Remove entire Jedox Worksheet-Server container Folder – navigate to Content Administration/Portal Content/Content Provided by Other Vendors/End User Content/Jedox: Worksheet-Server folder. Right click on it and from the context menu choose delete.
Jedox Worksheet-Server AppIntegrator iView
Technical
Data
|
Provider/Homepage |
Jedox AG |
|
Application
type |
Remote URL iView on Websource |
|
Technical
name |
com.jedox.jedox_worksheet_server_package |
|
Available
for Portal (Release) |
SAP |
|
Origin
of data |
Jedox
Worksheet-Server |
|
Languages |
English |
|
Support |
Tel: +49 (761) 15 14 7 0 |
Features
This package provides simple remote iView on Worksheet-Server as websource.
It features single-sign-on via SSO 2.0 ticket. User logged into Enterprise
Portal who uses Worksheet-Server iView will be
automatically signed into WorkSheet server and will
be able to use Worksheet-Server features from within Enterprise Portal.
Additionally Worksheet-Server will read Enterprise Portals theme (css) data and apply it to the Worksheet-Server in order to
preserve the same look and feel.