SAP DataSphere – Moving Objects: Table, Dataflow from one Space to another Space.

[vagarwal1]

In this article, we will learn how to move Remote Table, Local Table and Associated Dataflow from one space to another.

Pre-requite: For remote table export/Import, we need to define the connection in target space, like (identical) to source space. 

In Source Space:

Let us consider below End-to-End design Flow (Order cancellation) for moving from one space to another:

We are including below objects/artifacts for the movement:

• Remote table for reading data from source system.
• Dataflow – to capture required data from remote table and persisting on local table.
• Local table, which store the final result.

Export process:

Select the first Dataflow from lineage view and click the option to open in new window.

Select the option to export to CSN/JSON file:

This will export the Dataflow along with dependent objects like, Remote table, projection view and final local table into default download directory.

Once both Files are exported, switch to Target space in Data builder.

Choose the option “Import Objects from CSN/JSON File:

Select file to import and click on import. After select the file we will get option to import any selected object or all the objects together. It is important to import all the object to maintain the synchronization between them.

Click on “Import CSN File”, from the selection screen. Once the import is completed, you will get message as:

we can check the imported object in Data Builder Object list, along with its status (not deployed):

Complete the deployment of object and execute the Dataflow in the order as placed in the source space. Here, deploy remote table first by selecting the table and clicking Deploy. 

Validate the deployment is successful and you can see the data from source server within the remote table.

Now deploy the target table of the dataflow as it is prerequisite to execute the dataflow. We can check table deployment status in Table view -> right hand side (Blur button). Move the mouse, it will say no deployed. To deploy click on deploy option.

Finally deploy the Dataflow:

Now execute the dataflow:

Now click on final table to view the result of Dataflow:

Finally, Validate the lineage and data dependency to ensure it matches with the source system.