The SAP HANA input component is designed to retrieve data from an SAP HANA data source. When synchronizing data from SAP HANA to other data sources, it is essential to first set up the SAP HANA input component to access the data source, followed by configuring the target data source for synchronization. This topic describes the steps to configure the SAP HANA input component.
Prerequisites
Before starting, ensure the following prerequisites are met:
You have successfully created an SAP HANA data source. For more information, see Create an SAP HANA Data Source.
To configure the properties of the SAP HANA input component, the account must possess read-through permissions for the data source. Should these permissions be lacking, you must obtain the necessary permissions for the data source. For more information, see Manage Data Source Permissions.
Procedure
On the Dataphin home page, navigate to the top menu bar and select Development > Data Integration.
At the top of the integration page, choose Project (select the environment in Dev-Prod mode).
In the left-side navigation pane, click on the Batch Pipeline. From the Batch Pipeline list, select the offline pipeline you want to develop to access its configuration page.
Click Component Library in the upper-right corner to open the Component Library panel.
In the Component Library panel's left-side navigation, select Input. Locate the SAP HANA component in the input component list and drag it onto the canvas.
To configure the component, click the
icon on the SAP HANA input component card, opening the SAP HANA Input Configuration dialog box.In the SAP HANA Input Configuration dialog box, set the required parameters.
Parameter
Description
Step Name
The name of the SAP HANA input component. Dataphin automatically generates a step name, but you can modify it based on your business scenario. The naming conventions are as follows:
It can contain only Chinese characters, letters, underscores (_), and numbers.
It can be up to 64 characters in length.
Datasource
The drop-down list of data sources displays all SAP HANA data sources, including those for which you have read-through permissions and those for which you do not. Click the
icon to copy the name of the current data source.For data sources without read-through permissions, you can click Request next to the data source to request read-through permissions. For more information, see Request, Renew, and Return Data Source Permissions.
If you do not have an SAP HANA data source, click Create Data Source to create one. For more information, see Create an SAP HANA Data Source.
Schema (Optional)
The schema corresponds to the project to which the table in the data source belongs. If no schema is selected, the default schema with the same name as the current user is used.
Table
Select the source table for data synchronization. You can search for the table by entering a keyword or find it by entering the exact table name and clicking Exact Search. After selecting the table, the system automatically checks the table status. Click the
icon to copy the name of the selected table.Shard Key (Optional)
Used in conjunction with concurrency configuration. You can use a column in the source data table as the shard key. The field type must be an integer. It is recommended to use the primary key or an indexed column as the shard key.
Batch Read Count (Optional)
The number of records read at one time. When reading data from the source database, you can configure a specific batch read count (such as 1024 records) instead of reading one record at a time. This reduces the number of interactions with the data source, improves I/O efficiency, and reduces network latency.
Input Filter (Optional)
Specify the filter information for input fields, such as
ds=${bizdate}. Input filters are applicable in the following scenarios:Filtering a fixed portion of data.
Parameter-based filtering.
Output Fields
The output fields section displays all fields of the selected table. If you do not need to output certain fields to downstream components, you can delete the corresponding fields:
If you need to delete a small number of fields, you can click the Actions column's
icon to delete the extra fields.To delete many fields, click Field Management. On the Field Management page, select multiple fields and click the
icon to move the Selected Input Fields to the Unselected Input Fields section. 
Click Confirm to finalize the SAP HANA Input Component property settings.