Skip to Content
avatar image
Former Member

Connect HANA Express with MySQL via Smart Data Access

I need to connect my HANA Express VM with a MySQL database. What I did so far is:

0.) Registered VM and installed unixODBC (as described in Youtube Playlist)

1.) Downloaded ODBC driver installation files (rpm)

2.) sudo zypper install <rpm file>

3.) myodbc-installer -d -l

4.) cp /etc/unixODBC/odbc.ini ~/.odbc.ini

5.) cp /etc/unixODBC/odbcinst.ini ~/.odbcinst.ini

6.) nano ~/.odbc.ini

[ODBC Data Sources]
ds2 = myodbc5w
ds1 = myodbc5a
Default = Default

[myodbc5w]
Driver          = /usr/lib64/libmyodbc5w.so
DATABASE        = <sqldb>
DESCRIPTION     = MySQL ODBC 5.3 Unicode Driver test
SERVER          = <sqlip>
UID             = <sqluser>
USER            = <sqluser>
PASSWORD        = <pw>

[myodbc5a]
Driver          = /usr/lib64/libmyodbc5a.so
DATABASE        = <sqldb>
DESCRIPTION     = MySQL ODBC 5.3 ANSI Driver test
SERVER          = <sqlip>
UID             = <sqluser>
USER            = <sqluser>
PASSWORD        = <pw>

[Default]
Driver          = /usr/lib64/libmyodbc5a.so
DATABASE        = <sqldb>
DESCRIPTION     = MySQL ODBC 5.3 ANSI Driver test
SERVER          = <sqlip>
UID             = <sqluser>
USER            = <sqluser>
PASSWORD        = <pw>

7.) nano ~/.odbcinst.ini

[MySQL ODBC 5.3 Unicode Driver]
Driver=/usr/lib64/libmyodbc5w.so
UsageCount=1

[MySQL ODBC 5.3 ANSI Driver]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=1

[Default]
Driver=/usr/lib64/libmyodbc5a.so
UsageCount=1

8.) nano ~/.customer.sh

export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64
export ODBCINI=$HOME/.odbc.ini
export ODBCSYSINI=$HOME

9.) Restarted VM

10.) I can successfully connect by calling

isql myodbc5w <user> <pw>

11.) Also this call works

myodbc-installer -d -l

MySQL ODBC 5.3 Unicode Driver
MySQL ODBC 5.3 ANSI Driver
Default

Now my problem and questions:

Why won't also my Smart Data Access access the MySQL (it seems to connect, but can't list the tables)? And what shall I set the "Configuration File" property with? And what's wrong with the odbc / odbcinst files, that only "Default" works?

I adapted the odbc file from an example which was shipped with the ODBC installation...

See screenshot for my SDA settings (only "Default" data source worked for me yet).

I'm working for days now on this problem, any help is appreciated! Thanks!

sda-mysql.png (24.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Nov 06, 2017 at 12:14 PM

    Hi Daniel,

    I hitting the same wall. I think one reason is the property_orcl.ini. The file contain some queries, which are not valid for MySQL. I could not find a solution for a running version. Did someone has a property_mysql.ini which is running?

    Thx for your help!

    Ben

    Add comment
    10|10000 characters needed characters exceeded