[NIFI-7810] Improvement for 'Translate Field Names' for PutDatabaseRecord and ConvertJSONToSQL

• Type: Improvement
• Status: Patch Available
• Priority: Major
• Resolution: Unresolved
• Component/s: Extensions
• Assignee: ZhangCheng
• Reporter: ZhangCheng
• Created: 15/Sep/20 06:20
• Updated: 04/Apr/22 06:46

Description

'Translate Field Names' in PutDatabaseRecord and ConvertJSONToSQL can help us map the field and column by

private static String normalizeColumnName(final String colName, final boolean translateColumnNames) {
        return translateColumnNames ? colName.toUpperCase().replace("_", "") : colName;
 }

but this rule `colName.toUpperCase().replace("_", "")` is fixed. I think maybe we can define the rule using Expression Language.

It's vary useful for 'Translate Field Names', but sometimes, there will be column names such as 'AB' and 'A_B' in the table, and `colName.toUpperCase().replace("_", "")` can not help

Issue Links

• fixes: NIFI-5723 PutDatabaseRecord strips underbar character from column names
• links to: GitHub Pull Request #4528