Troubleshooting SAP HANA mappings configured with query objects

To troubleshoot issues with SAP HANA mappings that use query source objects, you need to configure the EnhancedHANAQueryCapabilities custom property for the Secure Agent.

This configuration can help you troubleshoot the following issues:

• - When you import data of the Decimal data type from SAP HANA, the precision of a Decimal field increases by 1 compared to its actual precision.
For example, if the actual precision of a Decimal field is 6, it displays 7 in the Fields tab of the Properties panel.
• - When a schema name specified in the Current Schema field differs from the default schema name associated with the user name in an SAP HANA connection and you create a target at run time in a mapping, the Secure Agent ignores the schema name specified in the Current Schema field in an SAP HANA connection and creates the target table in the default schema for users.
For example, when you specify the "CLOUD_USER" schema name in the Current Schema field and "HANA_USER" in the Username field in an SAP HANA connection, and create a target with the Create New at Runtime option, the Secure Agent creates the target table in the "HANA_USER" schema.
• - When a schema name specified in the Current Schema field differs from the default schema name associated with the user name in an SAP HANA connection and the custom query does not include a schema name, the Secure Agent ignores the schema name specified in the Current Schema field in an SAP HANA connection and uses the default schema for users.
• - Even though you specify an alias name for a column, the Secure Agent ignores the alias name for the column and displays the actual column name in the Fields tab.

To configure the EnhancedHANAQueryCapabilities custom property for the Secure Agent, perform the following steps:

1. 1Log in to Informatica Intelligent Cloud Services.
2. 2Select Administrator > Runtime Environments.
3. 3On the Runtime Environments page, select the Secure Agent.
4. 4Click Edit.
5. 5In the Custom Configuration Details section, select Data Integration Server as the service and PMRDTM_CFG as the type.
6. 6Enter EnhancedHANAQueryCapabilities in the Name field and set the value to true.
7. 7Click Save.