Importing and Exporting Objects in CSN/JSON Files

You can use the tools in certain Data Builder editors to import objects to and export objects from your space.

Prerequisites

To use the tools in certain Data Builder editors to import objects to and export objects from your space, you must have a scoped role that grants you access to a space with the following privileges:

  • Data Warehouse General (-R------) - To access SAP Datasphere.

  • Space Files (CRUD----) - To create, read, update, and delete objects in your spaces.

  • Data Warehouse Data Builder (CRUD----) - To create, edit, and delete Data Builder objects.

The DW Modeler role template, for example, grants these privileges. For more information, see Privileges and Permissions and Standard Roles Delivered with SAP Datasphere.

Object Types

The following object types can be exported and imported via CSN files:

Object Type

Details

Local Tables

The definition of a local table without delta capture contains the structure of the table only, and does not have dependencies on any other objects. The definition of a local table with delta capture enabled contains the definition of an additional internal table with the suffix _Delta. When you export a table with delta capture enabled, this table is exported too.

Remote Tables

The definition of a remote table contains information about its connection.

Views

The definition of a view contains the definitions of all its sources and any used data access controls. When you export a view, these objects are exported too.

Flows

The definition of a data flow, replication flow, or transformation flow contains the definitions of all its sources and its target table. When you export a flow, these objects are exported too.

Intelligent Lookups

The definition of an intelligent lookup contains the definitions of its input and lookup entities. When you export an intelligent lookup, these entities are exported too.

Analytic Models

The definition of an analytic model contains the definitions of its fact and dimension sources. When you export an analytic model, these entities are exported too.

E/R Models

The definitions of all the tables and views in the model are exported. The model itself is not exported.

Data Access Controls

The definition of a data access control contains the definition of its permissions entity. When you export a data access control, the permissions entity is exported too.

Task Chains

The definition of a task chain does not include the objects that it automates. These objects must be selected manually.