Skip to Content
Author's profile photo Former Member

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

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

 

Open Talend and create a project

1. Unzip Talend Open Studio you downloaded from Talend official site to your local folder;

2. Click “TOS_DI-win32-x86.exe” to start the studio;

/wp-content/uploads/2014/02/001_388887.png

3. On the first run, you could choose to import the Demo Project or create a new one. This time we could create a new project for the tutorial. Input the project name “SAPBlue_Project” and click “Create” button.

/wp-content/uploads/2014/02/002_388888.png

4. A wizard window will pop up. Input the description and click “Finish” button.

/wp-content/uploads/2014/02/003_388910.png

5. Select the project you just created and click “Open” button.

/wp-content/uploads/2014/02/004_388911.png

6. The registration window pops up. You can just click “Skip”.

/wp-content/uploads/2014/02/005_388912.png

7. The studio is opened.

/wp-content/uploads/2014/02/006_388913.png

 

Create a Job

1. Let’s create a new “Job” by click the hyperlink.

/wp-content/uploads/2014/02/007_388914.png

2. Input the Name/Purpose/Description and click “Finish”.

/wp-content/uploads/2014/02/008_388915.png

3. The Studio is fully opened for the new Job.

/wp-content/uploads/2014/02/009_388916.png

 

Create DB Connections

1. Expand the “Metadata” in “Repository” window.

/wp-content/uploads/2014/02/010_388917.png

2. Right-click and choose “Create connection”.

/wp-content/uploads/2014/02/011_388918.png

 

MySQL

1. Input the general information.

/wp-content/uploads/2014/02/012_388919.png

2. Choose “MySQL” in the “DB Type” dropdown list and input the server information.

/wp-content/uploads/2014/02/013_388920.png

3. Click “Check” button to make sure your configuration is right and then click “Finish”.

/wp-content/uploads/2014/02/014_388921.png

4. Right click the connection and select “Retrieve Schema”.

/wp-content/uploads/2014/02/015_388922.png

5. Click “Next” and then select two tables as following.

/wp-content/uploads/2014/02/016_388923.png

6. Click “Finish”.

/wp-content/uploads/2014/02/017_388924.png

 

Assigned tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Swapan Saha
      Swapan Saha

      This is part of SAP HANA Cookbook for MySQL Developers | SAP HANA. Please feel free to check out entire Cookbook.

      Regards,

      Swapan