Skip to Content
avatar image
Former Member

Questions on replication from non SAP source to SAP HANA

Hi All,

I have a couple of questions that I hope you can help me on. We are currently replicating from MS SQL to SAP HANA using SLT. My questions are as follows:

1) Is it possible to only replicate changes to a specific column and not replicate all the columns? I know this might cause inconsistencies but just a question posed by a developer using SLT on our company. My answer is it is not possible but someone might be able to answer if it is possible.

2) When I add a column in a replicated table from the source (SQL). How do I get this change pushed to SAP HANA? Is there a way to automate that? Or do we need to manually change in SAP HANA?

Thanks and hope to hear from you soon.

Robert

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 06, 2016 at 01:36 AM

    Hello Robert,

    Please go through the below ans to the questions.

    1. As per my understanding You cannot skip a column for replication but you can defiantly mask the table columns in tcode iuuc_repl_content

    2. whenever you make any changes to the table in source system you will have to replicate the table from SLT system for below 2 reasons;

    --> once you update any structure for a table the triggers on the table created by slt system will be deactivated thus the replication will not be available for that table

    --> HANA system will only understand the data coming via SLT system thus it will not be aware about the structural changes done to the table thus replication for that table has to be restarted.

    to restart replication of the table

    login to SLT system

    load the MT id for tht replication

    go to table overview

    click on data provisioning

    give table name

    select stop replication

    click ok

    in similar way start the replication of the tables

    this restart of replication will remove the logging table and the triggeres and recreate them as per new structure in case of any changes done.

    Let me know if this helps or if you need more information on this

    Regards,

    Amar

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Apologies for the late reply as I was snowed under some other work stuff. I have started looking into this again and working through the notes. So far, I haven't found anything that would help fix the issue but at least it gave me something to move forward troubleshooting the issue.

      Thanks again for the help.

      Robert