SAP Data Connection

  • Last update: December 02, 2024
  • Overview 

    Version 

    FineDataLink VersionFunctional Change
    4.0.10/
    4.1.12.2  
    • Supported Table Selection.

    • Renamed the data source SAP ERP to distinguish it from other supported methods of fetching data from ERP.

    Function Description 

    FineDataLink allows you to call functions that have been developed in the SAP system through RFC APIs to fetch data. 

    To achieve that, you need to connect FineDataLink to the SAP system first.

    Prerequisite 

    For details, see Overview of Data Connection.

    Importing Files 

    To connect to the SAP system, import the SAP API package and local library files and ensure they can be found by the running JVM.

    1. Download the file.

    Download the SAP file package of the appropriate version from the table below and decompress it to obtain files such as sapjco3.jar and sapjco3.dll.

    2. Upload the file.

    • For the FineOps-deployed project, upload the obtained files to the project mounting path /fdl/customlib/lib.

    • For the non-FineOps deployed project, upload the obtained files to the /webapps/webroot/WEB-INF/lib path of the project.

    3. Restart the FineDataLink project or the component.

    Server SystemSAP File Package
    Linux64 

    sapjco3_linux_64bit.rar

    iconNote:
    If you need to create multiple data connections to the same SAP database, use the following driver file.

    Driver.zip

    Linux32sapjco3_linux_32bit.rar
    Windows64sapjco3_windows_64bit.rar
    Windows32sapjco3_windows_32bit.rar

    iconNote:

    1. The JDK version needs to be 1.8, and the minor version needs to be above JDK8u102.

    2. If the data connection fails, you can try placing sapjco3.dll in the jre\bin path of the system.

    3. To connect to the SAP system on the Windows Server 2003 and Windows XP systems, download and install Microsoft Visual C++ 2005 SP1.

    4. Check the error message if the connection still fails. For example, if it indicates a failure in SAPJCO verification due to a missing dependency libstdc++.so (which is required by SAPJCO2 and not by SAPJCO3), you need to install the shared library.

    Procedure 

    Creating the Data Connection 

    1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, select a folder, and create a data connection, as shown in the following figure.

    2. Set the data connection name. You can also modify the directory of the data connection.

    3. Find the data source by searching the data source name or filtering the data source by Data Source Type, Supported Form, and Compatible Module, as shown in the following figure.

    4. Fill in the connection information and click Test Connection, as shown in the following figure.

    Setting ItemDescription
    Hostname

    Enter the hostname of the SAP application server, such as 192.168.1.123. 

    It is identical to the value of Application Server in the SAP system.

    System Number

    Enter the instance number, such as 00.

    It is identical to the value of Instance Number in the SAP system.

     

    Language Code

    Fill in the language code of the SAP system, such as EN.

    iconNote:
    You can find supported configuration items in SAP according to SAP Table T002.

    It is identical to the logon language on the SAP login page.

    Client Number

    Enter the SAP client number, which is the maximum effective collection of business and data managed by the SAP system, such as 000.

    It is identical to the value of Client on the SAP login page.

    Username

    Enter the SAP user account.

    It is identical to the value of User on the SAP login page.

    Password

    Enter the password of the SAP user account. 

    Pasting the copied password is not supported.

    It is identical to the value of Password on the SAP login page.

    SAP Router

    Enter the configuration information of the SAP router.

    The SAP router specifies the target SAP system, differentiating it from multiple applications on the same server. 

    It is identical to the value of SAProuter String in the SAP system.

    5. Click Test Connection. If the connection is successful, click Save, as shown in the following figure. 

    Fetching Data Using SAP 

    After the data connection is established, you can use it in Scheduled Task to fetch data from the SAP system. For details, see Overview of SAP RFC Input.


    附件列表


    主题: Data Source Configuration
    • Helpful
    • Not helpful
    • Only read

    滑鼠選中內容,快速回饋問題

    滑鼠選中存在疑惑的內容,即可快速回饋問題,我們將會跟進處理。

    不再提示

    9s后關閉

    Get
    Help
    Online Support
    Professional technical support is provided to quickly help you solve problems.
    Online support is available from 9:00-12:00 and 13:30-17:30 on weekdays.
    Page Feedback
    You can provide suggestions and feedback for the current web page.
    Pre-Sales Consultation
    Business Consultation
    Business: international@fanruan.com
    Support: support@fanruan.com
    Page Feedback
    *Problem Type
    Cannot be empty
    Problem Description
    0/1000
    Cannot be empty

    Submitted successfully

    Network busy