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.