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>’;