title: Connect HANA Express with MySQL via Smart Data Access
body: <p>I need to connect my HANA Express VM with a MySQL database. What I did so far is:</p>
  
  <p>0.) Registered VM and installed unixODBC (as described in Youtube Playlist)</p>
  
  <p>1.) Downloaded ODBC driver installation files (rpm)</p>
  
  <p>2.) sudo zypper install </p>
  
  <p>3.) myodbc-installer -d -l</p>
  
  <p>4.) cp /etc/unixODBC/odbc.ini ~/.odbc.ini</p>
  
  <p>5.) cp /etc/unixODBC/odbcinst.ini ~/.odbcinst.ini</p>
  
  <p>6.) nano ~/.odbc.ini</p>
  
  <pre><code>[ODBC Data Sources]
  ds2 = myodbc5w
  ds1 = myodbc5a
  Default = Default
  
  [myodbc5w]
  Driver          = /usr/lib64/libmyodbc5w.so
  DATABASE        = &lt;sqldb&gt;
  DESCRIPTION     = MySQL ODBC 5.3 Unicode Driver test
  SERVER          = &lt;sqlip&gt;
  UID             = &lt;sqluser&gt;
  USER            = &lt;sqluser&gt;
  PASSWORD        = &lt;pw&gt;
  
  [myodbc5a]
  Driver          = /usr/lib64/libmyodbc5a.so
  DATABASE        = &lt;sqldb&gt;
  DESCRIPTION     = MySQL ODBC 5.3 ANSI Driver test
  SERVER          = &lt;sqlip&gt;
  UID             = &lt;sqluser&gt;
  USER            = &lt;sqluser&gt;
  PASSWORD        = &lt;pw&gt;
  
  [Default]
  Driver          = /usr/lib64/libmyodbc5a.so
  DATABASE        = &lt;sqldb&gt;
  DESCRIPTION     = MySQL ODBC 5.3 ANSI Driver test
  SERVER          = &lt;sqlip&gt;
  UID             = &lt;sqluser&gt;
  USER            = &lt;sqluser&gt;
  PASSWORD        = &lt;pw&gt;
  </code></pre>
  
  <p>7.) nano ~/.odbcinst.ini</p>
  
  <pre><code>[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
  </code></pre>
  
  <p>8.) nano ~/.customer.sh</p>
  
  <pre><code>export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib64
  export ODBCINI=$HOME/.odbc.ini
  export ODBCSYSINI=$HOME
  </code></pre>
  
  <p>9.) Restarted VM</p>
  
  <p>10.) I can successfully connect by calling</p>
  
  <pre><code>isql myodbc5w &lt;user&gt; &lt;pw&gt;
  </code></pre>
  
  <p>11.) Also this call works</p>
  
  <pre><code>myodbc-installer -d -l
  
  MySQL ODBC 5.3 Unicode Driver
  MySQL ODBC 5.3 ANSI Driver
  Default
  </code></pre>
  
  <p><strong>Now my problem and questions:</strong></p>
  
  <p>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?</p>
  
  <p>I adapted the odbc file from an example which was shipped with the ODBC installation...</p>
  
  <p>See screenshot for my SDA settings (only "Default" data source worked for me yet).</p>
  
  <p><a href="https://i.stack.imgur.com/pTtiK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pTtiK.png" alt="enter image description here"></a></p>
  
  <p>I'm working for days now on this problem, any help is appreciated! Thanks!</p>