Data Provisioning using HANA studio

[former_member842146]

Hi Experts,

I have a requirement to perform full load for a table in SLT everyday as the data in source gets refreshed. As we do not have any full load option every day in SLT. I have written a script to achieve the same through HANA Studio using RS_ORDER and RS_STATUS table. After upgrade of SLT environment to SLT3.0 the RS_ORDER and RS_STATUS table are not receiving any updates, hence I am unable to replicate the table using HANA studio.

Is there any other way we can achieve full load for tables in SLT everyday or any other tables that can be used to perform data provisioning (Stop and Start replication) in SLT using HANA studio tables?

Thanks in advance!!

Regards,

Adithya

[ian_kirkman]

Hi Adithya,

Please see 3099036 - Can we schedule initial load for SLT table.

Regards,
Ian
SAP Product Support

[Cocquerel]

You may use UUC_RS_ORDER and IUUC_RS_STATUS tables at SLT server level instead.

[former_member842146]

Hi Michael,

I used to run a Pyspark script from databricks to connect to HANA DB and put an entry in RS_ORDER table to stop or start replication and check the status from RS_STATUS table. Is there a way we can connect directly to SLT to put an entry in IUUC_RS_ORDER table and fetch the details from IUUC_RS_STATUS table through a script?

[Cocquerel]

What is the underlying database of your SLT system ? If it is HANA, you can do the same way as today. If it is an other db like Oracle, you can create some virtual table on HANA target system on top of remote table IUUC_RS_* using SDA/SDI technology and then your script would access/update those table via HANA.