SAP Datasphere Local Table (File) Sources for Replication Flows

You can use local table (file) sources in a replication flow to replicate data from local table files to supported target connections. This allows you to reuse data that has already been loaded into SAP Datasphere without extracting it again from the original source system.

Prerequisites

  • The table cannot be shared from another space.

  • Initial and Delta and Delta Only load types are supported only if the table has Delta Capture enabled.

Supported Target Connections

You can replicate local table file sources to the following targets:

Procedure

  1. Open the replication flow in its editor.

  2. Choose Add Source Objects.

  3. Select the SAP Datasphere (HDL_FILES) connection.

  4. Browse or search for the Local Table File that you want to use as the source.

  5. Select the local table file and choose Add Selection.

Data Types

The following table shows how Datasphere Local Table (CDS) data types are mapped to internal data types.

CDS Data Type

SAP Datasphere

Binary

binary

Boolean

bool

Date

date

DateTime

timestamp

Decimal

decimal(p,s)

DecimalFloat

decfloat34

Double

float64

hana.BINARY

binary

hana.REAL

float32

hana.SMALLDECIMAL

decfloat16

hana.SMALLINT

int16

hana.TINYINT

uint8

Integer

int32

Integer64

int64

LargeBinary

binary

LargeString

string

String

string(n)

Time

time

Timestamp

timestamp

UInt8

uint8