Exporting data using tSAPHanaUnload
tSAPHanaUnload lets you export data from an SAP HANA database, which you
can import to a third-party storage such as Amazon S3.
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
- Creating the SAP HANA database connection
Specify your SAP HANA database in Talend Studio. - Creating and running the Job
Add components in to your design workspace and configure these before running the Job.