Transfer Data from SAP HANA to SAP Vora or Cloud Storage
SAP Data Hub provides capabilities that enable you to transfer data from an SAP HANA system to an SAP Vora system or to cloud storages.
Prerequisites
- You have created a connection to an SAP HANA system using the SAP Data Hub Connection Management application.
- You have created a connection to an SAP Vora system or to the required cloud storage using the SAP Data Hub Connection Management application.
Context
In the Modeler, configure and execute the Data Transfer operator in a graph to transfer data from SAP HANA to SAP Vora or to cloud storages.
Procedure
- Start the SAP Data Hub Modeler.
- In the navigation pane, select the Graphs tab.
-
In the navigation pane toolbar, choose + (Create
Graph).
The application opens an empty graph editor in the same window, where you can define your graph.
-
Select the operator.
A graph can contain a single operator or a network of operators based on the business requirement.
- In the navigation pane, choose the Operators tab.
- In the search bar, search for the Data Transfer operator.
- In the search results, double-click the Data Transfer operator (or drag and drop it to the graph editor) to add it as a process in the graph execution.
-
In the graph editor, double-click the Data
Transfer operator.
The application opens a form-based editor where you can define the source and target for data transfer.
-
Define the source for data transfer.
In the Source tab, provide details of the source dataset for the data transfer operation.
-
In the Connection ID field, enter a connection ID that provides a
connection to an SAP HANA system.
You can also click the browse icon to browse and select the required connection ID.
- In the Table Name field, click the browse icon to browse and select the required SAP HANA object.
-
In the Connection ID field, enter a connection ID that provides a
connection to an SAP HANA system.
-
(Optional) Import source dataset from the Metadata Catalog.
You can browse the folders in the Metadata Catalog and select the required data set.
- In the editor, choose Import from Catalog.
- Browse and select the required data set.
-
Choose OK.
The application automatically populates the connection details based on the selected data set. For more information on Metadata Catalog, see Manage Metadata in the Data Governance User Guide for SAP Data Hub.
-
Provide values to parameters.
If the selected SAP HANA objects are defined with parameters, then it is necessary to provide values to those parameters. The application automatically populates the default values, if any, that are already defined for the parameters.
- In the Variables text field, click the edit icon to provide values to the variables.
- In the Provide Parameter Values dialog box, select the variable, operator type, and provide the required values.
-
If you want to view only the mandatory parameters, choose
and select Show Mandatory Only.
- Choose OK.
-
Select columns.
Select the required columns from the source dataset that you want to project to the target.
-
Choose the Target tab.
In the Column Mapping section, the application displays all columns from the selected source.
- Select the columns that you want to project to the target and drag the cursor to the Target pane.
-
Choose the Target tab.
-
Filter columns.
You can filter conditions on columns in the source dataset and project only filtered values.
- At the top of the Operator editor, choose the Source tab.
- In the Filters text field, click the edit icon.
- In the Provide Filter Values dialog box, select the column and define the filter condition.
- Choose OK.
-
Define the target (SAP Vora).
If you want to use an SAP Vora table as the target dataset for data transfer, in the Target tab, provide details of the required SAP Vora table.
-
In the Connection ID text field, enter a connection ID that
provides a connection to an SAP Vora system.
You can also click the browse icon to browse and select the required connection ID.
-
In the HANA Wire Port text field, enter the SAP
HANA Wire port of the SAP Vora Transaction Coordinator, which is
determined as 3<XX>15, where <XX> is the instance number of
the SAP Vora cluster as configured in the SAP Vora Manager.
- In the Table text field, enter the SAP Vora table name to which you want to transfer the data.
-
In the Schema text field, enter the schema name of the SAP Vora
table selected in the previous step.
Optionally, in the Table text field, you can click the browse icon to browse and select the required SAP Vora schema and table.
-
In the Connection ID text field, enter a connection ID that
provides a connection to an SAP Vora system.
-
Define the target (cloud storages)
If you want to use any of the supported cloud storages as the target dataset for data transfer, in the Target pane, provide details of the required cloud storage.
-
In the Connection ID text field, enter a connection ID that
provides a connection to the required cloud storage.
You can also click the browse icon to browse and select the required connection ID.
-
In the Target text field, enter the path of the
file to which you want to transfer the data.
You can also click the browse icon to browse and select the required file location. If the selected connection has a root path specified in the connection definition, then the content of this field is relative to this path.
-
In the Connection ID text field, enter a connection ID that
provides a connection to the required cloud storage.
-
Map source and target columns.
In the Target tab, under the Column Mapping section, use the mapping editor to map the columns from the source dataset that you want to project to the target.
-
Map a source column with a target column by selecting the source column and dragging the
cursor to the target column.
-
Map a source column with a target column by selecting the source column and dragging the
cursor to the target column.
-
Save and execute the graph.
You can control the start and stop of the graph execution using the Workflow Trigger and Workflow Terminator operators respectively.
