Skip to Content
0

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

Mar 09 at 02:59 PM

128

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member
Mar 09 at 06:11 PM
-1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Marcus Zwirner
Mar 16 at 10:51 AM
0

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
Show 6 Share
10 |10000 characters needed characters left characters exceeded

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

0

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

0

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

0

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?

0

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

0

By reporting this to SAP Support as a bug.

0