Creating and running the Job - 7.2

SAP

Version
7.2
Language
English (United States)
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Data Governance > Third-party systems > Business applications > SAP components
Data Quality and Preparation > Third-party systems > Business applications > SAP components
Design and Development > Third-party systems > Business applications > SAP components

Add components in to your design workspace and configure these before running the Job.

Procedure

  1. Drag-and-drop the SAP HANA database connection you previously created into the design workspace.
  2. Add the tSAPHanaUnload component.
  3. Connect the components using the Trigger > OnSubjobOk.
    The following image displays the sample Job:
  4. Select tSAPHanaUnload and view the Basic settings tab.
    1. Mark the Use an existing connection checkbox.
    2. Select tDBConnection_1-SAPHANA option from the dropdown list.
    3. Enter the name of the SAP HANA database table that you wish to export in the Table field.
    4. Add the target location where you want to store the exported data in the Export location on the SAP HANA host field. This refers to a directory in your SAP HANA database local machine.
  5. Run the Job.

Results

All the data from the specified SAP HANA database table are exported and stored locally in the unload directory of your SAP HANA database machine. Note that you can find the exported data in a subdirectory of your target location.

tSAPHanaUnload exports and creates several files in the subdirectory, including the metadata of the SAP HANA table, the information about the extracted data, the information about the SAP HANA system, the commands for file import into SAP HANA, and so on. Be sure to look into the data.csv, which contains the data you need.

You can further use the exported data and send these to a third-party storage system of your choice.