IBM Db2 Data Connection

  • Last update: November 20, 2024
  • Overview 

    Version 

    FineDataLink VersionFunctional Change
    3.2Scheduled Task supported data reading from the IBM Db2 database.
    3.6.2Scheduled Task supported data writing into the IBM Db2 database.
    4.1.3Data Service supported the IBM Db2 database.
    4.1.4Data Pipeline supported data synchronization from the IBM Db2 database.
    4.1.11.4Real-Time Task supported data reading from the IBM Db2 database.

    Function Description 

    FineDataLink supports connection to the IBM Db2 database for data reading and writing using scheduled tasks, data reading using pipeline tasks, data reading using real-time tasks, and for releasing data services.

    Preparation 

    Version and Driver 

    Supported Database VersionDriver PackageDriver Name
    V9.7, V8.2, V10.5, and V11.1Db2.zipcom.ibm.db2.jcc.DB2Driver

    Connection Information Collection 

    Collect the following information before connecting FineDataLink to the database.

    • IP address and port number of the database server   

    • Database name

    • Username and password of the database   

    • Schema of the database to be connected

    Procedure 

    1. Log in to FineDataLink, choose System Management > Data Connection > Data Connection Management, and choose Create > Data Connection, as shown in the following figure. 

    iconNote:
    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. Find the IBM Db2 icon.

    3. Select Custom, add the downloaded driver, and fill in the connection information. You cannot set Schema unless the database is connected. Click Click to Connect Database and then select the schema, as shown in the following figure.

    4. Click Save to save the data connection.

    Data Source Usage 

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

    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

    After configuring the data source, you can use it in Real-Time Task. For details, see Overview of Real-Time Task.

     

     


    附件列表


    主题: 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