I. Overview
1. Version
Server Version | JAR packages | SAP dataset plug-in version |
|---|---|---|
| 10.0 | 2016-12-14 | V1.8.8 |
| 9.0 | 2016-12-14 | V1.8.4 |
| 8.0 | 2016-12-14 | V1.8.2 |
2. Features
When the 「SAP Dataset Plug-in」 is enabled, you can connect to the SAP system and add SAP dataset types to the dataset.
II. Preparation
1. Installing the SAP plug-in
To install the plug-in SAP dataset, refer to the following documentation.
Designer plug-in installation method refer to Designer Plug-in Management
To install the plug-in on the server, refer to Server Plug-in Management
2. Preparing the environment
To connect to the SAP system, you need to import the SAP interface package and native libraries and ensure that the running JVM can find the interface package and native libraries.
1)Windows system servers
The report project is deployed on a Windows server, using Tomcat as an example.
Note: First of all the SAP plug-in needs to be installed in the report project.
| 32 | JDK1.6 and above | sapjco3_windows_32bit | sapjco3.jar in the path %TOMCAT_HOME%\lib sapjco3.dll is placed in the path C:\Windows\System32 |
| JDK bits | JDK version | SAP packages | SAP file import path |
|---|---|---|---|
| 32 | JDK 1.8 and minor version at least JDK8u102 | sapjco3.jar in the path %TOMCAT_HOME%\lib sapjco3.dll is placed in the path C:\Windows\System32 | |
| 64 | JDK 1.8 and minor version at least JDK8u102J | sapjco3.jar in the path %TOMCAT_HOME%\lib sapjco3.dll is placed in the path C:\Windows\System32 |
Note 1: If the data connection fails, try placing the sapjco3.dll file in the bin directory of the system jre, e.g.%JAVA_HOME%\jre\bin
Note 2: Windows Server 2003 and Windows XP systems require Microsoft Visual C++ 2005 SP1 to be downloaded and installed when connecting to SAP.
32 bits Microsoft Visual C++ 2005 SP1 x86
64 bits： Microsoft visual c++ 2005sp1_x64.rar
2) Mac OS System Server
Click to download the driver atibsapjco3.rar，Once unpacked, you can place it in the…/FineReport/lib.
Open the designer bin directory, right-click on designer, select Show package contents and open the vmoptions.txt file as shown below.
Write in the file.-Djava.library.path=/Applications/FineReport10.0/lib（Path of the placed file）
Note: If both SAP and SAP BW plug-ins are installed, there may be a conflict that causes an error to be reported in the preview of one of the data sets.
3) Linux System Server
The report project is deployed on a Linux server, using Tomcat as an example.
Note: First of all the SAP plug-in needs to be installed in the report project.
| JDK bits | Package | SAP file import location |
|---|---|---|
| 32bits | sapjco3_linux_32bit | sapjco3.jar in the path %TOMCAT_HOME%\lib libsapjco3.so in the path %JAVA_HOME%\jre\bin libsapjco3.so under the folderusr\lib，if Linux is 64 bits，put under the pathusr\lib64 |
| 64bits | sapjco3_linux_64bit | sapjco3.jar put under the path%TOMCAT_HOME%\lib libsapjco3.so put under the path%JAVA_HOME%\jre\bin libsapjco3.so put under the pathusr\lib64 |
Note: If you still cannot connect, see the error message, e.g. verification of SAPJCO failed, missing dependency libstdc++.so "required for SAPJCO2 but not for SAPJCO3", then you need to install the shared library.
3. Local Designer
If the local designer uses the SAP data connection, download the JDK1.6 version of the SAP file package for Windows with the corresponding bit number, depending on the installed designer bit number.
| Number of designer bits | Packages | SAP file import location |
|---|---|---|
| 32bits | sapjco3_windows_32bit | sapjco3.jar put under the path %FR_HOME%\lib |
| 64bits | sapjco3_windows_64bit | sapjco3.jar put under the path%FR_HOME%\lib |
Note: Versions 8.0 and later require the SAP plug-in, which is installed as described in 3.1.
III.SAP Data Connection
1.Installing the SAP plug-in
Installing plug-ins SAP Dataset，Refer to the following documentation for installation instructions.
For the installation of the designer plug-in, please refer to Designer Plugin Management
To install the plug-in on the server, please refer to Server Plugin Management
2.Establish connection
Select 「Server > Define Data Connections」, click on the 「+」 button and select SAP as shown below.
Host name: The host name of the configured SAP on the LAN, you can also write the IP address of this machine. Note: Not the host name of the database server, but the IP of the SAP application server.
System Number: The property set in the SAP system for the port number of the interaction, generally 00, depending on the SAP system.
Client: The largest valid collection of business and data managed by the SAP system and an attribute of the SAP system, depending on the SAP system.
User: The user name of the account used when connecting to SAP. Note: Not the database user name, but the SAP user account to which the application is connected.
Password: The password of the account used to connect to SAP. Note: Not the database password, but the SAP user password of the connecting application.
Connection pool properties: capacity and maximum number of connections in the SAP system.
3.Test Connection
Click on 「Test Connection」, if the connection is successful then the SAP data connection is successfully completed, click on 「OK」 to exit the data connection setup panel.
Once the connection has been made, you can use this data connection on server data sets, template data sets, etc. to retrieve data from the SAP system via this data connection, as detailed in SAP Dataset 。
