Skip to Content

HANA CDS association prevent ODBC to works correctly

Hi all,

I've created a very simple entity test to association :

      entity Product {
            key id : Integer;
            name : String(50);
      };
     
      entity Stock {
            key id : Integer;
            product_id: Association[1..1] to Product;
      };

After activating the .hdbdd file I get 2 tables : Product & Stock.

When I look to Stock table I get a field named : produit_id.id

This field with a "." inside the name prevent any ODBC Connection to the table.

I've tested with MS product like Excel and Access and I get Invalid column name.

When I remove the association the field returns to it's expected name : product_id

and OBDC Connection is OK....

Add comment
10|10000 characters needed characters exceeded

  • I can't on ODBC connection with Excel or Access you do not have access to the SQL.

    On Access you generate attached tables, but wizard failed because field name shouldn't have any "." inside...

  • Get RSS Feed

1 Answer

  • Sep 01, 2017 at 04:58 AM

    Have to tried to enclose the column name with quotes, e.g. "product_id.id"?

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded