Exporting data using tSAPHanaUnload - 7.3

SAP

EnrichVersion
Cloud
7.3
EnrichProdName
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
EnrichPlatform
Talend Studio
task
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

tSAPHanaUnload lets you export data from an SAP HANA database, which you can import to a third-party storage such as Amazon S3.

For more technologies supported by Talend, see Talend components.

This sample scenario includes a Talend Job that shows you how you can use tSAPHanaUnload when exporting massive data all at once.

Let's imagine you have a table in the SAP HANA database that contains the information of your clients. This information includes their names, their companies, their email addresses, and other important data needed to transact business. Now, you want to export these data and store them in an external storage system. It may be possible to directly export data from the SAP HANA database, but we are talking about a huge amount of client information. This is where tSAPHanaUnload becomes useful.

Prerequisite

  • Ensure that you have access to both the SAP HANA database engine and the unload directory