HANA SDA to MySQL with ODBC

[Former Member]

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

property_mys.ini.txt.zip

[klaus_alfes]

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

[williams_ruter3]

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

[Former Member]

Hello Williams,

I will try to create table and try to retrieve data.

We use user SYSTEM with standard installation HANA privilege and for connection we use MySQL user. We test MySQL user with SQL workbench we can browse the data.privilege

Any privilege must add to HANA or MySQL user?

BR,

Tino

[williams_ruter3]

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