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 |
SAP IQ(Sybase) Data Type | Internal Types |
INTEGER,SMALLINT | Long |
DECIMAL,FLOAT,REAL | Double |
CHAR,VARCHAR,TEXT,UNICHAR,UNIVARCHAR | String |
DATETIME | Date |
IMAGE | Bytes |
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 |
Was this page helpful?