SAP HANA Connector

Back Next

SAP HANA sources in mappings

To read data from an SAP HANA database, configure an SAP HANA object as the Source transformation in a mapping.

Specify the name and description of the SAP HANA source. Configure the source, query options, and advanced properties for the source object.

The following table describes the source properties that you can configure for an SAP HANA source:

Property	Description
Connection	Name of the SAP HANA source connection.
Source Type	Type of the SAP HANA source object available. You can choose from the following source types: Single Multiple Query Parameter
Object	Name of the SAP HANA source object.
Filter	A simple filter includes a field name, operator, and value. Use an advanced filter to define a more complex filter condition, which can include multiple conditions using the AND or OR logical operators. Use single quotes to specify a filter value.
Select distinct rows only	Select this option to extract only distinct rows.

When you configure a mapping, you can configure the advanced source properties. The following table describes the SAP HANA advanced source properties:

Property	Description
Pre SQL	Pre-SQL command to run before reading data from the source.
Post SQL	Post-SQL command to run after reading data from the source.
Output is Deterministic	When you configure this property, the Secure Agent does not stage source data for recovery if transformations in the pipeline always produce repeatable data.
Output is repeatable	When the output is deterministic and the output is repeatable, the Secure Agent does not stage the source data for recovery.
Tracing level	Amount of detail that appears in the log for this transformation. You can choose terse, normal, verbose initialization, or verbose data. Default is normal.