SAP Datasphere - Updating a source object (CDS)

[Max_Post]

Hi everyone,

I'm wondering if it is possible to update a source object in a replication flow.

Currently I have a replication flow that has 1 object with 228 columns. I've extended the CDS view with 1 field so now I have 229 columns in the CDS view. However, the replication flow doesn't see this change. The only solution I have found is to add the same object again, but that means I have to manually check the projection (Mappings and filters) and all the RF settings.

See the attached screenshot as a reference. The first row is the original replication flow, the seconds row is the same object added for the second time, now displaying the correct amount of 229 columns.

[Martin_Kuma]

Hi, this is not supported. The reason is overall build of the replication flow --> inbound, outbound, delta... . Need for consistency, automation, persistency, ... .

When you modify the source (the CDS in your case), you have to go to the target object (in DSP go to the target table). Add the new field in the target table manually (type, length). Then go back to the replication flow and use the 'map to existing target' function. Afterwards re-deploy the flow and run it. 

Your new field will appear and will also be populated. 

Not really easy in case you do a lot of changes -> a lot of new fields. Deleting is not in anyway 🙂

Cheers, Martin 

[edwineko]

Hi Martin,

We have a problem regarding the update Source from CDS too.

When we try to mapping to existing Target Objects the target didn't Change.

What is best practice when we must update Source CDS with a new column?

Thankyou.

Edwin Eko

[Martin_Kuma]

Hi, you need to stop the replication flow first. Then it is possible to change it. Try and please post results, will help others as well 🙂

[edwineko]

Hi Marti,

[edwineko]

Hi Martin,

We already stop the replication flow. But the FIeld not automatically updated or there is mecanism to update the field. Except readd the source to the replication flow. But after we do this, we have to remove the old source and target on replication flow and completely new process from updated source to new Target and we cannot use old Target.

Thankyou

Regards

Edwin EKo