Skip to Content
May 06, 2016 at 03:27 PM

Replication to different schema


Hi Experts,

We are replicating from ECC to HANA DB.

Our requirement is to replicate data to specific schema but not with that default schema user (or same as configuration name).

Suppose, the DB user which we want to use is "DB1" and we want data in Schema "ECC".

There can be two cases:

Case 1:

We can keep configuration name as "ECC" so that the schema name will be "ECC".

But in this case replication user will also be "ECC" which we dont want.

How to use different replication username than default config/schema name ??

Case 2:

I can keep whatever name for configuration but replicate data only to specific schema.

How to point replication to specific schema??