Skip to Content
0

Smart Data Integration - Flowgraph - Updates & Deletes

May 04, 2017 at 05:11 PM

176

avatar image
Former Member

I'm trying to reproduce a scenario where data are replicated (in real time) from an Oracle 11g Database, transformed through SDI (flowgraph) and then loaded into to my cloud Hana Database.
Below is my flowgraph (I'm using SDI in the Web IDE):

So far I have:

  • Created a DataSource, using my virtual table (MY_ORACLE_TABLE)

  • Created a filter (MY_FILTER), in order to create fields that will be used in my HANA Database

  • Create a DataSink, pointing to an existing Hana table (MY_HANA_TABLE) - I'm using a HANA Sequences using the field ID and preserving the ID from the Oracle table, naming it as "LEGACY_ID".


In the scenario described above, I've noticed the following behaviour:

When a record is UPDATED in my Oracle Database:
A new record is created in my HANA Database, BUT it doesn't use the sequence specified (see picture above)

When a record is DELETED in my Oracle Database:
Nothing happens in my HANA Database, no change can be seen in my Hana table.
---

My question is, basically:

How can I guarantee that each update/delete carried out in my Oracle Database is, automatically, replicated to my Hana Database in a scenario like described here?

---

PS. 1 - I've have already tried to reproduce this scenario using extra columns (change time and change type) and using an extra table for history ("history table setting"), but I got the same results mentioned before.

PS. 2 - When I replicate data, without transformation, each insert/update/delete on my Oracle database is replicated perfectly to my Hana database.

---

VERSIONS

Data Provisioning Agent Version (Windows 10) = 2.1.0.0

SAP HANA Version = 1.00.122.04.1478575636

2.png (36.7 kB)
3.png (44.0 kB)
4.png (74.7 kB)
5.png (21.2 kB)
1.png (10.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers