You want to replicate view in Oracle to HANA , while the view include two tables in different tablespace.

Preparation:

Table in oracle:

Table 1:  SLT_DEMO , SLT_DEMO is in tablespace TEST
/wp-content/uploads/2016/07/sltora1_987349.png

Table 2 : SLT_DEMO1 , SLT_DEMO1 is in tablespace SLTORA

/wp-content/uploads/2016/07/sltora2_987405.png

/wp-content/uploads/2016/07/sltora3_987402.png

VIEW : VIEW_TEST

/wp-content/uploads/2016/07/sltora4_987403.png

/wp-content/uploads/2016/07/sltora5_987404.png

Go to SE16 -> Table “IUUC_DB_TAB_KEYS” -> add entry like below.

DBCON NAME:  input your db connection

DB SCHEMA: your DB schema

INT TABNAME: The View that you want to replicate

INT FIELDNAME: The key of the view

IS KEY : X

KEY POSITION : The position of the KEY

/wp-content/uploads/2016/07/sltora9_987440.png

P.S. If you you have several keys, you could add severy entries one by one.

e.g.

/wp-content/uploads/2016/07/sltora10_987441.png

1. Go to transaction LTRS, then we need to define the advanced settings before we replicate the view.

  •    Transaction LTRS -> Choose your Mass Transfer ID -> Right click on “Table Settings” -> Add table -> Here we add the base table “SLT_DEMO”.
  •    In “Structure Template”, we input the view that we want to replicate
  •    In “Deviating Table Name” , here we can define the name that you want in your target system. If you want the name in target system the same as your source system. Here you can input “VIEW_TEST” the same name as the view in your source Oracle system.
  •    For “View for Initial Load” and “View for Replication”, we input the same as “Structure Template”
  •    Then click “Save” button to save the settings.

/wp-content/uploads/2016/07/sltora6_987406.png

   Click on “Table Structure” tab, you will find that the structure has already been changed to the same as the view in Oracle.

/wp-content/uploads/2016/07/sltora7_987425.png

   Right click on “Performance Options” -> Add table SLT_DEMO -> Change the “Reading Type” to “5 Sender Queue”. And click on “Save” button.

/wp-content/uploads/2016/07/sltora8_987426.png

2. Go to transaction LTRC -> Table overview -> Data Provisioning -> Start replication of table “SLT_DEMO” .

/wp-content/uploads/2016/07/sltora11_987442.png

/wp-content/uploads/2016/07/sltora12_987452.png

And you will find that the view VIEW_TEST has aleady been replicated to HANA.

/wp-content/uploads/2016/07/sltora13_987462.png

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Ertugrul Öztürk

    Hello Klaus Liu,

    you used two different tablespaces in the source system in your scenario. Is there a possibility to connect to those tablespaces with SLT separetely?

    Kind Regards

    (0) 
  2. Sylvain LABAYSSE

    Hi Klaus,

    I wonder if you would keep track of changes happening in each table with your test scenario. I mean, my understanding is that SLT will see you oracle view as a database table without keys, so you just define table keys in SLT. But how is SLT going to create triggers on that view? Could you maybe show us the triggers created in your database?

    Thanks

    (0) 

Leave a Reply