Modeling Guide

Transfer Data from SAP HANA to SAP Vora

SAP Data Hub provides capabilities that enable you to transfer data from an SAP HANA system to an SAP Vora system.

Prerequisites

  • You have created a system with a connection (connection type: SAP HANA SDI) to an SAP HANA system (system type: SAP HANA).
  • You have created a system with a connection (connection type: SAP VORA Catalog) to an SAP Vora system (system type: SAP Vora).
  • You have created a project.

Context

To transfer data, you only need to select the source data in the required SAP HANA system and the target SAP Vora table (in an SAP Vora system) to which you wan to transfer the data. Based on the source and the target that you define, the tool creates an SAP HANA data set, an SAP Vora data set, and a data transfer task.
  • The SAP HANA data set references the selected SAP HANA system and a data source within the selected system.
  • The SAP Vora data set references the selected SAP Vora system and an SAP Vora table within the selected system.
  • Execute the data transfer task that the tool creates to transfer data from the SAP HANA system to the SAP Vora system.

    Alternatively, you can also schedule the task execution within a task workflow and monitor the status of the execution in the SAP Data Hub cockpit.

Procedure

  1. Start the SAP Data Hub cockpit in a Web browser.
  2. In the System Status section, choose the Modeling tile.
    The cockpit opens the SAP Data Hub Modeling tool in a new tab in the same browser window.
  3. In the navigation pane, right-click the project within which you want the system to create the data transfer task and choose Transfer Data.
    The tool opens the Transfer Data wizard. Use this wizard to define the source and the target. You can also use this wizard to execute the data transfer task, which the tool creates based on the source and target definitions.
  4. Select the source.
    In the Select Source, you can select the source that you want to use for the data transfer.
    1. In the Select Connection dropdown list, select the required connection to an SAP HANA system.
      The tool displays all data sources grouped under its schemas that are available in the selected connection.
    2. Expand the schema and select the required data source.
  5. Provide values for variables.
    If the selected data source is defined with variables, then the tool prompts you to provide values to these variables. The tool also displays the default values, if any, defined for the variables.
    1. In the Variable Values dialog box, select the variable, operator type and provide the required values.
    2. If you want to view only the mandatory variables, select Show Mandatory Only.
    3. Choose Apply.
  6. Choose Step 2 to proceed and select the required columns (measures and dimensions).
  7. Select columns.
    In the Select Columns pane or in the Select Measures and Dimensions pane, the tool displays all the columns available in the data source (catalog table, dimension, or CUBE).
    1. Select the required columns (or measures and dimensions for CUBES) that you want to project to the SAP Vora table and choose > (Add).
      You can also sort the order of the selected columns when projecting it to the SAP Vora table. In the Selected Columns, Selected Measures, or Selected Dimensions pane, use the Move Up, Move Down, Move to Top, or Move to Bottom icons to sort the selected measures and dimensions.
  8. Choose Step 3 to proceed and select the target SAP Vora table.
  9. Select the target SAP Vora table.
    In the Select SAP Vora Table pane, select the required SAP Vora system and browse to the required SAP Vora table within this system. The SAP Vora table is the target destination for the data transfer task.
    1. In the Select Connection dropdown list, select the required connection to an SAP Vora system.
    2. In the Description text field, provide a description.
    3. In the Table field, browse to the required SAP Vora table.
  10. Choose Step 4 to validate, create, and execute the data transfer.
  11. Create and execute the data transfer.
    In the Summary pane, based on the source and target, the tool displays the default names of the SAP HANA destination, SAP HANA data set, SAP Vora destination, SAP Vora data set, and the data transfer task. You can edit the default names of these objects.
    1. If you want the tool to create these objects without executing the data transfer task, choose Create.
      You can browse these objects in the project explorer. If you want to execute the data transfer task, right-click the task in the project explorer and choose Execute.
    2. If you want the tool to create and also execute the data transfer task, select the Execute checkbox and choose Create.
      The tool performs an immediate and one time execution of the data transfer task. After executing the tasks, you can monitor the execution status in the SAP Data Hub cockpit.

Next Steps

After creating and executing the data transfer task, you can still edit the SAP HANA data set and SAP Vora data set from the project explorer. But, you can edit them only in the Transfer Data wizard and not in the destination or data set editor.