tencent cloud

Feedback

SAP IQ(Sybase) Data Source

Last updated: 2024-11-01 17:48:13

    SAP IQ Offline Single Table Read Node Configuration

    
    
    
    Parameters
    Description
    Data Source
    Available SAP IQ Data Source
    Database
    Supports selecting or manually entering the database name to be read By default, the database bound to the data source is set as the default database. For other databases, the database name must be entered manually. When the data source network is disconnected and database information cannot be directly retrieved, the database name can be entered manually. Data synchronization is still possible when the Data Integration network is connected.
    Schema
    Supports selecting or manually entering the data mode to be read
    Table
    Supports selecting or manually entering the table name to be read
    Split Key
    You can use a column in the source data table as the partition key; it is recommended to use the primary key or an indexed column as the partition key. Only integer-type fields are supported
    When reading data, data sharding is performed based on the configured fields, enabling concurrent reads and improving data synchronization efficiency

    Data type conversion support

    Read

    SAP IQ(Sybase) Data Type
    Internal Types
    INTEGER,SMALLINT
    Long
    DECIMAL,FLOAT,REAL
    Double
    CHAR,VARCHAR,TEXT,UNICHAR,UNIVARCHAR
    String
    DATETIME
    Date
    IMAGE
    Bytes

    Write

    Internal Types
    SAP IQ(Sybase) Data Type
    Long
    INTEGER,SMALLINT
    Double
    DECIMAL,FLOAT,REAL
    String
    CHAR,VARCHAR,TEXT,UNICHAR,UNIVARCHAR
    Date
    DATE,TIME,TIMESTAMP
    Bytes
    IMAGE
    
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support