cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Data Services creates SAP HANA tables in uppercase instead of case sensitive

Donatas
Participant
0 Kudos

Hello,

When I am loading data into SAP HANA 2.0 using SAP Data Services 4.2 Template Table functionality the resulting target table and column names in SAP HANA automatically are created in uppercase although I am trying to create those in case sensitive manner.

Is it possible to keep the case sensitive names of tables and columns while creating them using Template Table in SAP HANA?


Thank you,

Donatas Budrys

Accepted Solutions (0)

Answers (2)

Answers (2)

MarcusZwirner
Advisor
Advisor
0 Kudos

Hi Donatas,

just including the table name of your template table in quotation marks (e.g. "TemplateTable") should preserve the mixed case table name.

And the column names depend on the names in the transform before the template table.

Best regards
Marcus
Donatas
Participant
0 Kudos

Hi, Marcus,

Thank you for your feedback. Yes, I've tried to do as you've mentioned but unfortunately the problem wasn't solved.

If I include the template table name in quotation marks i.e. "TemplateTable" I am getting the following result:

  1. Table name and column names in DataFlow are shown in mixed-case.
  2. Table name in DataStore is shown in mixed-case, column names in upper-case.
  3. The table and column names in HANA gets created in upper-case.
  4. An error is generated during table load because in the INSERT statement the table name is written in mixed-case and the column names are written in upper-case.

More ideas are very welcome 🙂

Best regards,

Donatas Budrys

former_member187605
Active Contributor
0 Kudos

Also put the lowercase and mixed-case column names within double quotes in the Query transform before the template table.

Donatas
Participant
0 Kudos

Hi, Dirk,

Thank you for your feedback and suggestion. Indeed it works. If I put double quotes around the last query's column names the table columns are created in mixed-case and insert and select also uses mixed-case column names.

But the problem still remains with table name. Although I've put the table name in double quotes in Template Table dialog window and the table name is shown with mixed-case in DataStore the LOAD and INSERT statements send the SQL statements with upper-case table name into HANA database. It means that the table is created with upper-case table name and then follows an error in Data Services when it tries to load or select from this table.

Actually it seems that there is a problem with Template Table functionality in Data Services that it uses upper-case statements with HANA.

More ideas?

Thank you in advance.

Best regards,

Donatas Budrys

former_member187605
Active Contributor
0 Kudos

I cannot check, because I currently don't have access to HANA.

When you say INSERT and LOAD statements fail, because they have the table name in uppercase, doesn't that mean that the table was created in mixed case?

Why do you insist on doing so?

Donatas
Participant
0 Kudos

Hi, Dirk,

If it would be a new Data Services project on HANA most probably it would be best to go with all upper-case scenario. But if it's a migration project from the database where all tables and columns are mixed-case into HANA it would take some efforts to transition all mixed-case into HANA all upper-case because all the DataFlows in Data Services also use mixed-case naming. This is why I expect to be able to retain mixed-case tables and columns during the migration into SAP HANA. And almost everything goes well except that no matter if I specify the double quotes around the table the Data Services Template Table feature sends the DROP and CREATE statements into SAP HANA with upper-case table names. In this case SAP HANA table is created in upper-case and the Template Table INSERT and LOAD statements fail because the INSERT and LOAD uses mixed-case table names (if table was enclosed in double quotes in Template Table).

It's a conceptual question - how to make SAP Data Services fully work with SAP HANA in mixed-case scenario when Template Table feature fails to complete it's job correctly.

Thank you for your feedback.

Best regards,

Donatas Budrys

former_member187605
Active Contributor
0 Kudos

By reporting this to SAP Support as a bug.

Former Member
0 Kudos

My understanding is the table names are NOT case sensitive in HANA.

Donatas
Participant
0 Kudos

Hi, Xuelian,

Thank you for your feedback. I suppose that table names are case sensitive in HANA though.

And if I create a table in SAP HANA using SAP Data Services Template Table functionality instead of "MyTable" the "MYTABLE" is created. How can I force SAP Data Services Template Table to create the table with mixed-case name "MyTable"?


Thank you.

Donatas Budrys