Sync Data from MySQL to HANA DB with Pentaho (Part...
Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
This document is for the introduction of the basic function of Pentaho and how to export the data from MySQL and import into HANA Database. Here is Part I.
Before Start
You need to copy the jar files of database connector for both MySQL and HANA DB to the library folder of Pantaho before we start this ETL tool. Here is the list:
1. MySQL: mysql-connector-java-5.1.28-bin.jar
You may download the file from MySQL official website.