Archived data in SAP

[nabeelaslam1994]

Hi Team,

When pulling data from SAP into Snowflake, Do you know what happens when the data gets deleted at source? Also, Are there archive tables that exists at source? Do we need to configure it separately?

[SushilKumar]

Hello @nabeelaslam1994 

Thanks for reaching out to Qlik via Qlik Community Support page. Any replication tools is designed to capture DML from the generated change logs of the hosting database. no matter what the operation is. If any DML happened on the tables which are participating in the replication setup. replication tools Extract changes and convert them to SQL and apply to the target endpoint. 

Regards,

Sushil Kumar

[SachinB]

Hello @nabeelaslam1994 ,

Thanks for reaching out Qlik community support portal.

• Replication tools are designed to capture Data Manipulation Language (DML) operations from the change logs of the hosting database.

• These tools monitor and capture any DML changes, regardless of the specific operation (e.g., INSERT, UPDATE, DELETE).

• When DML operations occur on tables that are part of the replication setup, the replication tools extract these changes.

• The extracted changes are then converted into equivalent SQL statements.

• Finally, the replication tools apply these SQL statements to the target endpoint, ensuring data consistency between the source and target databases.

Regards,

Sachin B