This blog is part of “HANA Cookbook for MySQL Developers”.

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.

/wp-content/uploads/2014/02/018_388928.png

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

T_002.png

* 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.

/wp-content/uploads/2014/02/020_388930.png


Input Definition

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

/wp-content/uploads/2014/02/021_388931.png

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

/wp-content/uploads/2014/02/022_388932.png

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

/wp-content/uploads/2014/02/023_388933.png

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

/wp-content/uploads/2014/02/024_388934.png

5. Choose the connection we just created for MySQL.

/wp-content/uploads/2014/02/025_388935.png

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

/wp-content/uploads/2014/02/026_388936.png

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

/wp-content/uploads/2014/02/027_388937.png


Map Data

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

/wp-content/uploads/2014/02/028_388938.png

2. Drag and drop it to the design area.

/wp-content/uploads/2014/02/029_388939.png

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

/wp-content/uploads/2014/02/030_388940.png

4. Click “tMap_1”.

/wp-content/uploads/2014/02/030_388940.png

5. Do it again for another.

/wp-content/uploads/2014/02/031_388942.png

6. Double click the “tMap_1”.

/wp-content/uploads/2014/02/032_388943.png

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

/wp-content/uploads/2014/02/033_388944.png

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

/wp-content/uploads/2014/02/034_388945.png

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

/wp-content/uploads/2014/02/035_388946.png


Output Data to HANA DB

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

/wp-content/uploads/2014/02/036_388947.png

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

/wp-content/uploads/2014/02/037_388948.png


Run the Job

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

/wp-content/uploads/2014/02/038_388949.png

2. Then the job finished.

/wp-content/uploads/2014/02/039_388950.png

3. We check the HDB and here they are.

/wp-content/uploads/2014/02/040_388951.png


<<over>>

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply