본문 바로가기

IT/SAP

How to Connect MARIADB using SDA in SAP HANA

Test Environment:
– SAP HANA Version: 2.00.042.00.1564994110 (fa/hana2sp04)
– MariaDB Version: 10.3.11

 

Set the settings in the following order:

  • Install unixODBC
  • Install MariaDB odbc driver
  • Set <SID>adm user’s environment(.customer.sh, .odbc.ini, etc.)
  • Create SDA Remote Source using adaptor with MYSQL.
  • Create credential for MariaDB

Sample of create credential for SDA
Create SQL:
CREATE CREDENTIAL FOR USER <HANA USER> COMPONENT ‘SAPHANAFEDERATION’ PURPOSE
‘<SDA NAME>’ TYPE ‘PASSWORD’ USING
‘user=<remote db user name>;password=<remote db user password>’;
Modify SQL:
ALTER CREDENTIAL FOR USER <HANA USER> COMPONENT ‘SAPHANAFEDERATION’ PURPOSE
‘<SDA NAME>’ TYPE ‘PASSWORD’ USING
‘user=<remote db user name>;password=<remote db user password>’;