Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

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.

    Add comment
    10|10000 characters needed 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

  • Mar 16 at 10:51 AM

    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
    Add comment
    10|10000 characters needed characters exceeded