Use Talend to Sync Data from MySQL to HANA (Part II)

This document would introduce the basic function of Talend. We would use this ETL tool to sync data from MySQL to SAP HANA Database. Here is Part II.

SAP HANA Database

1. If you have a look at the “DB Type”, you would find the “SAPHana” option.

2. But unfortunately, since currently we have not related component for output operation, we choose traditional “General JDBC” connection type.

* You could use the parameter “currentschema” to set the schema info.
* You need the driver “ngdbc.jar” for SAP HANA Database.
* Input “saphana_id” in the “Mapping file” textbox.

3. Now we have our connection ready.

Input Definition

1. We try to read data from MySQL. So we find the component in “Databases/MySQL”

2. Drag and Drop the component to the design area.

3. Click the “tMysqlImput_1” and see the “Component” panel below.

4. Select “Repository” for “Property Type”.

5. Choose the connection we just created for MySQL.

6. Input “orders” in “Table Name” field.

7. Create another “tMysqlInput” component for table “customers”.

Map Data

1. We use a “tMap” component to do “Join” operation. Input “tMap” in the search textbox and hit Enter.

2. Drag and drop it to the design area.

3. Right click one of the inputs and choose “Row/Main”.

4. Click “tMap_1”.

5. Do it again for another.

6. Double click the “tMap_1”.

7. Build the “Join” relation by drag and drop.

8. Click “Add” icon on the right side and add the following info.

9. Map the field by drag and drop and click “OK” button.

Output Data to HANA DB

1. Add a “tJDBCOutput” component on the design area and fill in the info as following.

2. Link the “tMap_1” with “tJDBCOuput_1” by right-click and choose “Row/out1”.

Run the Job

1. Click “run” button in the menu and the job is running.

2. Then the job finished.

3. We check the HDB and here they are.

<>