cancel
Showing results for 
Search instead for 
Did you mean: 

Replicate an oracle view with SLT

0 Kudos

Hi -

Using Oracle 11g and SLT 2011_1_731 Patch 7 with Hana rev 82

I am trying to replicate oracle views in hana through SLT

Scenario 1:

tables T2 and T3 with View T2_T3_view

If I follow this thread 

It creates the view as a table in hana  but does not populate it with any data.

Scenario 2 -

I have 2 oracle tables - T4 and T5.  I have a view T4_T5_VIEW that joins the 2 tables.

I followed steps in a document I received to replicate the view syntax as well as the tables.

1) replicated both tables T4 and T5 - success

2) stopped replication on T4

    table exists in hana with data but no replication

3) using LTRS, assigned the view T4_T5_VIEW to table T4

4) changed the performance option

5) restarted replication on T4

The view gets created as a table, but table T4 gets and error and does not replicate.

The view gets no data

What is the proper process for an oracle table?

I have a very complex view with 5 source tables I want to replicate.

Thanks

Diane

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi,

Have you ever solved this issue?

I'm facing similar issue when I'm replicating views from SYBASE ASE.

Regards,

Chong

Former Member
0 Kudos

Dear Diane,

So far from my experience, it is not possible to replicate a view like you replicate a table.
What you can do is the following:
- Replicate all underlying tables

- After that replicate the view, using the name of the view and the option "Create Table / DB View"

Thus the view is kind of copied to the HANA database and can be used there. Anyhow all changes of the view in the sourcesystem after the "copy" will not be copied automatically into the HANA, you would need to do this manually.

Regards

Konstantin

Former Member
0 Kudos

Diane,

This is Srini. I hope my solution is working fine.

Approach:

Migrate required tables from Oracle to HANA. And identify procedures, functions and cursor used  in view. Than create Scripted Calculation views using same cursor logic and combine all views into one output Calculation view.

You need Oracle and HANA skills to complete this work around.

Thanks

Srinivas