Skip to Content
avatar image
Former Member

HANA SDA to MySQL with ODBC

Dear All,

I am trying to use HANA SDA to connect to MySQL server, but always get error "SAP DBTech JDBC: [476]: invalid remote object name: Unable to retrive remote metadata for .. : line 0 col 0 (at pos 0)";

I checked my MySQL server and I saw the login success which came from the HANA.

From SQL statement, remote source look as follows?

We use HANA 1.0 SP 09.

Please help, thank you.


BR,


Tino


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 11, 2016 at 09:33 PM

    Hello Tino,

    For your screen i can see that you are connected to SQL, can you try to create another table in SQL and try to retrieve data  from it ? also what are the privilege granted for the user who make the connection ? check it out.

    Williams

    Add comment
    10|10000 characters needed characters exceeded

    • Hey Tino,

      Sorry for the delay of answer, the missing permission is from SQL, make sure the user have the necessary privileges in order to browse the schema.

      Which schema the table belongs to ?

      Williams

  • avatar image
    Former Member
    Aug 05, 2016 at 01:08 PM

    Hi Tino,

    I saw that you already connected a mySQL database to HANA SDA successfully.

    We have actually the same requests, but we didn't find an "official" statement from SAP that mySQL is supported to be connected.

    Can you provide some more information how you did it ....

    (e.g. I saw in your screenshot a file "property_mys.ini" ....)

    Thx in advance

    Klaus

    Add comment
    10|10000 characters needed characters exceeded