...

Setting up SAP Connectivity within IBM Cognos Virtual View Manager

by user

on
Category: Documents
1

views

Report

Comments

Transcript

Setting up SAP Connectivity within IBM Cognos Virtual View Manager
Guideline
Setting up SAP Connectivity
within IBM Cognos Virtual View
Manager
Product(s): IBM Cognos Virtual View Manager
Area of Interest: Infrastructure
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
2
Copyright and Trademarks
Licensed Materials - Property of IBM.
© Copyright IBM Corp. 2009
IBM, the IBM logo, and Cognos are trademarks or registered trademarks of
International Business Machines Corp., registered in many jurisdictions worldwide.
Other product and service names might be trademarks of IBM or other companies. A
current list of IBM trademarks is available on the Web at
http://www.ibm.com/legal/copytrade.shtml
While every attempt has been made to ensure that the information in this document
is accurate and complete, some typographical errors or technical inaccuracies may
exist. IBM does not accept responsibility for any kind of loss resulting from the use of
information contained in this document. The information contained in this document
is subject to change without notice.
This document is maintained by the Best Practices, Product and Technology team.
You can send comments, suggestions, and additions to [email protected]
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
3
Contents
1
INTRODUCTION ............................................................................................ 4
1.1
1.2
PURPOSE .............................................................................................................. 4
APPLICABILITY ....................................................................................................... 4
2
INSTALLING THE SAP R/3 CONNECTIVITY ADD-ON .................................... 4
3
INSTALLING THE SAP JAVA CONNECTOR LIBRARY ..................................... 5
4
CREATING A DATA SOURCE AND IMPORTING METADATA........................... 6
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
4
1 Introduction
1.1
Purpose
This document outlines the steps required to connect IBM Cognos Virtual
View Manager to a SAP R/3 data source.
1.2
Applicability
The techniques and product behaviours outlined in this document apply to:
• IBM Cognos Virtual View Manager 8.4 27.23-0 using the 2.1.6 SAP
SAP Java Connector (JCo) adaptor.
2
Installing the SAP R/3 Connectivity Add-On
Although the SAP data service is part of the IBM Virtual View Manager install
media download, it is not installed by default. In order for the SAP data
source to appear in the available data sources, an additional add on will need
to be installed.
To install Data Services for SAP on Windows:
1. Shut down the IBM Virtual View Manager service, if it’s running.
2. Within the IBM Virtual View Manager installation package. Locate and
double-click the installer, CADS_460_sap_windows_install32.exe to
begin the installation process.
This installation must be performed on the computer that has the IBM
Virtual View Manager server component installed.
3. The installer window should appear. Click the Next button to display
the license agreement page. If the license agreement is acceptable
click the Accept radio button.
4. Click Next to continue the install.
5. Select the appropriate IBM Cognos Virtual View Manager installation
directory and click the Next button.
6. Click the Next button to create the shortcuts.
7. Click the Install button to begin the installation.
8. Click the Next button, then the Done button to quit the installer.
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
3
5
Installing the SAP Java Connector Library
In order for the SAP Java Connector (JCo) 2.1.7 to function properly, it
requires a Java Runtime Environment of 1.3 or higher. It also requires a RFC
runtime library of version 6.40 or higher. To install JCo for windows:
1. Unzip the appropriate distribution package into an arbitrary folder.
2. If an older librfc32.dll in the system32 directory, back it up and
replace it with the one that comes with JCo.
3. Copy the sapjcorfc.dll to the system32 directory. If an older one
exists back it up and replace it with the one that comes with JCo.
4. Copy the sapjco.jar to the IBM Virtual View Manager Server install
directory under the ..\ vvm\apps\dlm\app_ds_sap\lib directory.
5. Start the IBM Virtual View Manager service. Once the IBM Virtual
View Manager service is restarted, the jar file should be loaded by the
application.
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
4
6
Creating a Data Source and Importing Metadata
The IBM Cognos Virtual View Manager is now configured to connect to SAP
R/3. The following section will step a user through the creation of a SAP data
source within IBM Cognos Virtual View Manager Studio.
1. After signing into IBM Virtual View Manager, right click on the Shared
folder and select the “New Data Source”
2. Within the Add Physical Data Source dialog box, Select SAP from the
list and click the Next button.
3. Within the New Physical Data Source dialog box, enter the information
below and click the Next button.
• Name: This is the name of the data source as it will be
displayed within the IBM Cognos Virtual View Manager Studio.
• Application Server: This is the host name of SAP system
• System Number:
• Client:
• User: This is the user id that is going to be used to connect to
the SAP system.
• Password: This is the SAP password for the user identified in
the User field.
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
4. The New Physical Data Source dialog box should now display the
metadata available from the SAP system as illustrated below.
7
Setting up SAP Connectivity within IBM Cognos Virtual View
Manager
5. For this particular document, the raw R/3 table VBFA was selected
from Tables\V\VB\.
6. Click Finish to complete the import. The metadata should now be
available on within the left hand resource tree as per the image
below.
7. To sample the data for the data, select the VBFA table object within
the left hand resource tree.
8. Right-click and from the available menu select the Show Contents.
When the query completes, the sample records will display at the
right hand, bottom results pane.
8
Fly UP