SAP HANA is an in-memory computing platform that can be deployed on premises or on the cloud. It features high-performance data queries. You can directly query and analyze a large amount of real-time data without performing operations such as modeling and aggregation. This topic describes the parameters supported by SAP HANA Reader and how to configure it by using the code editor.

Parameters

Parameter Description
username The username for accessing SAP HANA.
password The password for accessing SAP HANA.
column The columns to be synchronized. Set the value to an asterisk (*) if all the columns in the source table are to be synchronized.
table The name of the table to be synchronized.
jdbcUrl The JDBC URL for connecting to SAP HANA. Example: jdbc:sap://127.0.0.1:30215? currentschema=TEST.
splitPk The field used for data sharding when SAP HANA Reader extracts data. If you specify the splitPk parameter, the table is sharded based on the shard key specified by this parameter. Data Integration then runs concurrent threads to synchronize data.

Currently, the splitPk parameter supports data sharding only for integers. If no integer fields exist, do not specify this parameter.

Configure SAP HANA Reader by using the codeless UI

Currently, the codeless user interface (UI) is not supported for SAP HANA Reader.

Configure SAP HANA Reader by using the code editor

In the following code, a node is configured to synchronize data from SAP HANA to MaxCompute.
{
    "type": "job",
    "steps": [
        {
            "stepType": "saphana",
            "parameter": {
                "UserName":"Username",
                "Password":"Password",
                "column": [
                    "Column 1",
                    "Column 2",
                    "Column 3"
                ],
                "connection": [
                    {
                        "table": [
                            "The name of the table to be synchronized."
                        ],
                        "jdbcUrl": [
                            "jdbc:sap://127.0.0.1:30215? currentschema=TEST"
                        ]
                    }
                ],
                "splitPk": "Column 1" // The field used for data sharding. If you specify the splitPk parameter, the table is sharded based on the shard key specified by this parameter.
            },
            "name": "Reader",
            "category": "reader"
        },
        {
            "stepType": "odps",
            "parameter": {
                "partition": "",
                "truncate": true,
                "datasource": "example", // The connection name.
                "column": [
                    "*"
                ],
                "table": ""
            },
            "name": "Writer",
            "category": "writer"
        }
    ],
    "version": "2.0",
    "order": {
        "hops": [
            {
                "from": "Reader",
                "to": "Writer"
            }
        ]
    },
    "setting": {
        "errorLimit": {
            "record": ""// The maximum number of dirty data records allowed.
        },
        "speed": {
            "concurrent": 2,// The maximum number of concurrent threads.
            "throttle": false,// Specifies whether to enable bandwidth throttling. A value of false indicates that the bandwidth is not throttled. A value of true indicates that the bandwidth is throttled. The maximum transmission rate takes effect only if you set this parameter to true.
        }
    }
}