Mysql--Pentaho how to export the data from MySQL and import into HANA Database

这篇文档介绍了如何利用Pentaho将MySQL数据库中的数据导出并导入到HANA数据库中。首先需要将MySQL和HANA数据库的jar文件添加到Pentaho库中。然后在Pentaho中创建转换，设置输入和输出，使用Stream Lookup进行字段映射，并通过Table Output组件写入HANA数据库。最后通过Select Values调整输入输出的数据结构，并运行转换完成数据迁移。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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.

2. Double click the icon on the design panel and the property window pops up. Click the “New” button to create a new database connection.

3. We first create a MySQL connection. Click the “Test” button to verify the configuration.

4. It seems to work.

5. Go back to the Table Input property window and Click the “Get SQL select statement…” button.

6. Choose the “customers” table.

7. Click “OK” and you may choose whether include the field’s name in the SELECT statement.

8. Click “OK” button and the Table Input for “customers” is ready.

9. We create another Table Input for “orders” table in MySQL.

Use “Stream Lookup” for fields-mapping

1. Drag and drop “Stream Lookup” component from the Design Panel.

2. Hold down the “Shift” key and draw a line between the Table Input and Stream Lookup.

3. Double click the Steam Lookup and set the configuration. This is for the mapping of Customer Name. Click “OK” button to finish the configuration.

Create “Table Output” for HANA Database

1. Drag and drop the Table Output component.

2. Create a new database connection for HANA Database. Currently, there is no specific connection type for HDB, so we could use generic JDBC connection.

3. Test the connection configuration.

4. Set the Table Output configuration. We use the table “ORDER_INFO_KETTLE” for data destination.

Use “Select values” to map the data structure of Input and Output.

1. Drag and drop the Select Values component to the design area.

2. Link the Select Values component with the Stream Lookup.

3. Link the Select Values with Table Output.

4. Double click the Select Values component to open the property window. Click “Get fields to select” button to get the fields info from the Stream Lookup.