Tencent Cloud

SAP HANA Data Source

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

Use Limits
Note:
Supports reading view tables.
SAP HANA Offline Single Table Read Node Configuration
﻿
﻿
﻿
Parameters
Description
Data Source
Available SAP HANA Data Sources.
Database
Supports selecting or manually entering the database name to be read
By default, the database bound to the data source is used as the default database. Other databases need to be manually entered.
If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Schema
Supports selection or manual input of the Schema name to be read.
Table
Supports selecting or manually entering the table name to be read.
Split Key
You can use a column from the source data table as a split key; it is recommended to use the primary key or an indexed column as the split key. Only fields of integer type are supported.
When reading data, data sharding is performed based on the configured fields to achieve concurrent reading, improving data synchronization efficiency.
Filter Conditions (Optional)
Fill in the corresponding filter statement according to the data type. This statement will serve as the filter condition for the data to be synchronized. Limit keywords are not supported at present. SQL syntax aligns with the selected data source.
SAP HANA Offline Single Table Write Node Configuration
﻿
﻿
﻿
Parameters
Description
Data Destination
SAP HANA Data Source to be written.
Database
Supports selection or manual input of the database name to write to
By default, the database bound to the data source is used as the default database. Other databases need to be manually entered.
If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Schema
Supports selection or manual input of the Schema name to be read.
Table
Supports selection or manual input of the table name to write to
If the data source network is not connected and the table information cannot be fetched directly, you can manually enter the table name. Data synchronization can still be performed when the Data Integration network is connected.
Whether to Clear Table
You can manually choose whether to clear this data table before writing to the SAP HANA data table.
Batch Submission Size
The size of records submitted in a single batch can be set. This value can greatly reduce the number of network interactions between the data synchronization system and SAP HANA, and improve overall throughput. If this value is set too high, it may cause the data synchronization process to run into OOM exceptions.
Pre-Executed SQL (Optional)
The SQL statement executed before the synchronization task. Fill in the correct SQL syntax according to the data source type, such as clearing the old data in the table before execution (truncate table tablename).
Post-Executed SQL  (Optional)
The SQL statement executed after the synchronization task. Fill in the correct SQL syntax according to the data source type, such as adding a timestamp (alter table tablename add colname timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP).
Data type conversion support
Read
SAP HANA Data Types
Internal Types
BIGINT,INTEGER,SMALLINT,TINYINT
Long
DECIMAL,FLOAT,REAL,DOUBLE
Double
CHAR,VARCHAR,NVARCHAR,CLOB,NCLOB
String
TIME,DATE,TIMESTAMP
Date
BLOB,VARBINARY
Bytes
BIT,BOOLEAN
Boolean
Write
Internal Types
SAP HANA Data Types
Long
BIGINT,INTEGER,SMALLINT,TINYINT
Double
DECIMAL,FLOAT,REAL,DOUBLE
String
CHAR,VARCHAR,CLOB,NVARCHAR,NCLOB
Date
DATE,TIME,TIMESTAMP
Bytes
BLOB,VARBINARY
Boolean
BIT,BOOLEAN

tencent cloud

Recent Pages

SAP HANA Data Source

Use Limits

SAP HANA Offline Single Table Read Node Configuration

SAP HANA Offline Single Table Write Node Configuration

Data type conversion support

Read

Write

Was this page helpful?

Was this page helpful?

Parameters	Description
Data Source	Available SAP HANA Data Sources.
Database	Supports selecting or manually entering the database name to be read By default, the database bound to the data source is used as the default database. Other databases need to be manually entered. If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Schema	Supports selection or manual input of the Schema name to be read.
Table	Supports selecting or manually entering the table name to be read.
Split Key	You can use a column from the source data table as a split key; it is recommended to use the primary key or an indexed column as the split key. Only fields of integer type are supported. When reading data, data sharding is performed based on the configured fields to achieve concurrent reading, improving data synchronization efficiency.
Filter Conditions (Optional)	Fill in the corresponding filter statement according to the data type. This statement will serve as the filter condition for the data to be synchronized. Limit keywords are not supported at present. SQL syntax aligns with the selected data source.

Parameters	Description
Data Destination	SAP HANA Data Source to be written.
Database	Supports selection or manual input of the database name to write to By default, the database bound to the data source is used as the default database. Other databases need to be manually entered. If the data source network is not connected and the database information cannot be fetched directly, you can manually enter the database name. Data synchronization can still be performed when the Data Integration network is connected.
Schema	Supports selection or manual input of the Schema name to be read.
Table	Supports selection or manual input of the table name to write to If the data source network is not connected and the table information cannot be fetched directly, you can manually enter the table name. Data synchronization can still be performed when the Data Integration network is connected.
Whether to Clear Table	You can manually choose whether to clear this data table before writing to the SAP HANA data table.
Batch Submission Size	The size of records submitted in a single batch can be set. This value can greatly reduce the number of network interactions between the data synchronization system and SAP HANA, and improve overall throughput. If this value is set too high, it may cause the data synchronization process to run into OOM exceptions.
Pre-Executed SQL (Optional)	The SQL statement executed before the synchronization task. Fill in the correct SQL syntax according to the data source type, such as clearing the old data in the table before execution (truncate table tablename).
Post-Executed SQL (Optional)	The SQL statement executed after the synchronization task. Fill in the correct SQL syntax according to the data source type, such as adding a timestamp (alter table tablename add colname timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP).

SAP HANA Data Types	Internal Types
BIGINT,INTEGER,SMALLINT,TINYINT	Long
DECIMAL,FLOAT,REAL,DOUBLE	Double
CHAR,VARCHAR,NVARCHAR,CLOB,NCLOB	String
TIME,DATE,TIMESTAMP	Date
BLOB,VARBINARY	Bytes
BIT,BOOLEAN	Boolean

tencent cloud

Sign Up

Log in

Recent Pages

SAP HANA Data Source

Use Limits

SAP HANA Offline Single Table Read Node Configuration

SAP HANA Offline Single Table Write Node Configuration

Data type conversion support

Read

Write

Was this page helpful?

Was this page helpful?