SAP HANA Invalid column name

[karandama2006]

There is an issue , I'm not sure with Talend or SAP

When there is a column mentioned in Camel case in SAP HANA , eg: Wave

and we try to insert data into that column from Talend , we get invalid column name error 

[FATAL]: apd_bi_pulse.j00_pulse_transfer_sql_hana_0_1.j00_pulse_transfer_sql_hana - tDBOutput_1 SAP DBTech JDBC: [260]: invalid column name: WAVE
com.sap.db.jdbc.exceptions.JDBCDriverException: SAP DBTech JDBC: [260]: invalid column name: WAVE

Any leads on how to tackle this ?

Column names are usually case insensitive but they are not in SAP HANA

This is what I found :
Names are not  case sensitive . For example, CUSTOMER and Customer are the same, but object names are converted to uppercase when they are stored in the SAP  HANA  database. However, if you enclose a name in quotation marks, it is  case sensitive .

[Anonymous]

Hello,

The connection is established successfully from talend to SAP HANA? The table name and schema name which your are trying to query do exist in SAP HANA?

Are you able to fire direct query from tSAPHANARow component to query your column?

Best regards

Sabrina

[karandama2006]

Hi Sabrina , 

The answer is YES to all your questions . 
For now , I've asked the owner of HANA database to capitalize all their columns after that everything worked fine.

But this seems like a Bug in Talend.

Thanks ,

Karan

[Anonymous]

Hello,

For this case sensitive issue, could you please clarify in which Talend version/edition you are?

Best regards

Sabrina

[karandama2006]

I'm on Talend 7.1.1 the latest version

[Anonymous]

Hello,

SAP HANA supports case sensitive columns for a table. While querying such tables it is necessary to have quotes around the fields name else it throws "Invalid column name" error.

With our SAP HANA Input component, you can manully modify the query and add quotes the field name.  Does this issue only repro on SAP HANA output?

Best regards

Sabrina

[karandama2006]

Hi Sabrina,
Thats right, In input components we can do manual modification, but the issue occurs in output component while trying to insert data.. I haven't tried adding quotes in the output schema but just changing the case does not work.
Regards,
Karan Dama

[Anonymous]

Hello @karandama2006 

Thanks for your information. Indeed, we could add a feature to handle the case sensitive columns in SAP HANA table. I will report this issue/new feature to our PMs  to see if there is any workaround for that. We will keep you posted.

Best regards

Sabrina

[karandama2006 · Accepted solution]

Hi ,

I came across this type of table again which has case sensitive columns , I found a workaround to insert data through output component .
In edit schema - > dbcolumn 
We need to surround the concerned column which is in Camel-case with quotes and escape sequence
So if the column name is Text , change it to  \"Text\" in the output component schema in the "dbcolumn" column and it works.

It would be better if Talend does this automatically for us , may be in future release but  for now this solution works.

Regards,

Karan Dama

[Anonymous]

Hello @karandama2006 

Thanks for you feedback and sharing your solution with us on community.

Feel free to create a workitem jira issue on talend bug tracker.

https://jira.talendforge.org/secure/Dashboard.jspa

Best regards

Sabrina