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.
下载地址参照:(30天试用)http://www.pentaho.com/download
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.
http://dev.mysql.com/downloads/connector/j/
2. Hana DB: ngdbc.jar
You could find this file in the directory of you SAP HANA Studio:
\%HANA Studio%\configuration\org.eclipse.osgi\bundles\2000\1\.cp\lib
3. Target folder: \%pentaho%\design-tools\data-integration\lib
Open Pentaho and create a transformation
1. Open “Data Integration”.
2. Click “Cancel”.
3. Now the “Spoon” is open.
4. Create a new Transformation.
5. Now you could drag and drop the components from Design panel.
Create Inputs
1. Drag and Drop “Table input” component to the design panel.