Data Connection to SAP Sybase

  • Last update:  2024-10-19
  • 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

    Attachment List


    Theme: Data Center
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

    鼠标选中内容,快速反馈问题

    鼠标选中存在疑惑的内容,即可快速反馈问题,我们将会跟进处理。

    不再提示

    7s后关闭

    反馈已提交

    网络繁忙