SAP HANA Data Connection

  • Last update: September 19, 2024
  • Overview 

    FineDataLink Version
    Functional Change
    3.5.2

    Scheduled Task supported data reading from SAP HANA 1.0.

    Scheduled Task supported data writing into SAP HANA 1.0.

    4.1.4The source end of Data Pipeline supported the following versions of SAP HANA: SPS 05 to SPS 12 (1.0) and SPS 00 to SPS 07 (2.0).
    4.1.5.4Scheduled Task supported the reading from and writing into SAP HANA 2.0.
    4.1.6.3Data Service supported SAP HANA 1.0 and 2.0.
    4.1.7.3Pipeline Task supported data writing into SAP HANA.

    FineDataLink supports connection to the SAP HANA database for data reading/writing using scheduled tasks and pipeline tasks and for releasing data services.

    Preparation 

    Version and Driver 

    Download the driver package and upload it to FineDataLink. For the specific steps of uploading the driver package, see Driver Management

     Supported Database VersionDriver Package Download
    V1.0   

    ngdbc-2.9.16.jar

    V2.0

    Connection Information Collection

    Collect the following information before connecting FineDataLink to the database.

    • IP address and port number of the database server

    • Username and password of the database

    • Database pattern

    Procedure 

    1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection.

    Note: If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission.

    2. Click the SAP HANA icon.

    3. Click Custom, select the uploaded driver mentioned in the Version and Driver section, and fill in the connection information. You cannot set Pattern unless the database is connected. Click Click to Connect Database and then click Pattern.

    4. Click Test Connection. If the connection is successful, click Save to save the configuration.

    Data Source Usage

    After configuring the data source, you can use it in Data Development. For details, see Overview of Data Development.

    After configuring the data source, you can use it in Data Pipeline. For details, see Overview of Data Pipeline.

    After configuring the data source, you can use it in Data Service. For details, see Overview of Data Service.

    Note: The real-time synchronization function of Pipeline Task does not support the following data types: TEXT, BINTEXT, ARRAY, and ST_POINT.


    附件列表


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

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

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

    不再提示

    10s後關閉

    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