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.
Input types for HANA modelling views
You can use the following input types when you read data from HANA modelling views:
•Variables. A variable is a filter. A variable is associated with a field, for example, company name, of the view.
Provide the variable value in the field that you specified in SAP.
The following image shows the variable VAR_01 associated with COMPANY and PO_CATEGORY fields:
•Parameters. An input parameter is a placeholder to the query. You can use parameters to insert values for analytical views and calculation views. The data type for an input parameter in Data Integration is char. Specify the data for input parameters in the format that you defined in SAP.
When you create a mapping and use input parameters, do not connect the input parameters in the source to the output fields. Otherwise, the mapping fails. For more information, see Input parameter types.
Input parameter types
When you select a HANA modelling view, Informatica adds a prefix to the parameter name. The prefix is used to indicate the parameter type.
You can use the following types of parameters:
•Mandatory Parameter. A parameter for which you are required to specify a value. For example, in the field PARAM_M_ip_param_4_empID1, PARAM_M is the prefix for a mandatory parameter that Informatica adds. ip_param_4_empID1 is the parameter name that is a part of HANA modelling views.
•Optional Parameter. A parameter for which you do not need to provide a value. For example, in the field PARAM_O_par_4_sal_hike, PARAM_O is the prefix for an optional parameter that Informatica adds. par_4_sal_hike is the parameter name that is a part of HANA modelling views.
The following image shows the mandatory parameter PARAM_M_ip_param_4_empID1 and the optional parameter PARAM_O_par_4_sal_hike:
