Skip to Content
Oct 20, 2021 at 12:56 PM

Table replicator operator in SAP Data Intelligence

657 Views Last edit Oct 22, 2021 at 03:41 PM 3 rev

Hello Folks,

I am trying to use the table replicator operator in SAP DI, for initial and delta load.

Initially I tried the Initial and delta load in SAP HANA as source and target DB and it worked fine but now I have started working with actual data a source: Azure SQL DB, I ran the graph with table replicator operator and it failed with error " CREATE TABLE permission denied at the database".

I understand "CREATE TABLE permission at the source database " is one of the pre-requisites for table replicator operator, but how can I asses the changes being made by this operator at the source database. If I request this access from the DB team, would it be a right approach going forward in production as well?

Secondly, while testing with HANA DB(src and target), there are missing key and values ( max/no of batches and number of rows) in checkpoint table. Besides, shadow and shadow view are never populated with any value. Is that expected behavior or am I missing something?

Also, the primary key details of the source table are missing in check point table and the target HANA table.

Need suggestions!