Data Connection to SAP Sybase

  • Last update:October 19, 2024
  • Overview

    Version

    FineBI Version
    Functional Change

    6.0

    /

    Application Scenario

    This document introduces how to connect to the SAP Sybase data source.

    Preparation

    Version/Driver

    Database VersionDriver PackageDriver

    IQ16.0/IQ16.1/ASE16.0

    jconn4.jar

    com.sybase.jdbc4.jdbc.SybDriver

    Connection Information Collection

    Before connecting the database, you need to collect the following information:

    • IP address and port number of the server where the database is located

    • Username and password of the database

    • Schema of the database to be connected

    Connection Procedure

    1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection, as shown in the following figure.

    新建数据集截图.png

    iconNote:
    If you are not the admin, you can configure data connections only after the admin assigns you the permission on Data Connection Management. For details, see Data Connection Permissions Overview.

    2. Find the SAP Sybase icon, as shown in the following figure.

    图标截图.png

    3. Select Customfrom the Driver drop-down list, select the driver uploaded in section "Version/Driver", and enter the connection information collected in section "Connection Information Collection", as shown in the following figure.

    iconNote:
    You can optionally modify other advanced settings. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

    111111.png

    4. Click Click to Connect Database, and select the database schema after successful connection. Finally, save the data connection, as shown in the following figure.

    连接成功111.png

    Adding Database Tables to FineBI

    Two methods are available to add database tables to FineBI.

    公共数据库新建数据集截图.png

    附件列表


    主题: Data Preparation
    • 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