Skip to Content
avatar image
Former Member

Replicate from multiple oracle schemas in single instance to hana

Hi -

I am replicating Oracle Leasing to Hana and have 50 tables spread across 7 schemas.

I want to use a single Hana schema for the connection.


For example

schema1 has 5 tables

schema2 has 4 tables


User SLT_ADMIN has the following Oracle privs:

  • create any table
  • create trigger
  • select any table


From Hana studio, I try to replicate table

     schema1.table1


Hana returns message that table has no columns and prefixes table as if it is SLT_ADMIN.SCHEMA1.TABLE1.


In a different test, I create the same tables in the SLT_ADMIN schema and can replicate successfully.


What configuration do I need to setup as SLT_ADMIN to allow me to replicate tables owned by other schemas?


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 13, 2015 at 10:55 PM

    Hello,

    Pl. include the schema mapping information using the DBCO transaction in SLT server.  As soon as the schema name is added, SLT knows where to pull from in Oracle.

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      for this setup you need for every single schema one configuration within the SLT system. Technically this setup is interpreted as an n:1 replication.

      So you would create 5 configurations with source schema1, 2,3,4,5 and as the configuration name (that also represent the target schema name) you would choose the same name.

      All 5 sources will be now replicated to the target schema. I would suggest that you use the LTRC to start the replication of the tables and not the HANA Modeler Provisioning UI (because there you will find only the meta table informtion from the last added source schema).

      Best,
      Tobias