IT/SAP

How to Connect MARIADB using SDA in SAP HANA

SAP_BASIS 2020. 3. 12. 13:56

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

'IT > SAP' 카테고리의 다른 글

The following template is missing: sap_sm.xls  (0) 2020.04.28
Post process(check), after implement Support Packages(JAVA)  (0) 2020.03.12
Authorization for HANA Cockpit User  (0) 2020.03.12
CTS File Download Report  (0) 2019.09.03
Exam PRODS4PRESALES  (0) 2019.01.09