cancel
Showing results for 
Search instead for 
Did you mean: 

Replicating data to an existing table

kr_pavankumar
Contributor
0 Kudos

Hi Experts,

A table is existing on HANA with some data records. Now, I would like to replicate the data from SQL to this existing table.

Is it possible to achieve this using SLT. Is there any workaround to get the data to an existing table. Thanks!

--

KRPK

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Pavan,

When you say table is there in HANA, which schema is it in ..  when u configure the SLT it will have it own schema for a perticular system..

when you from AQL do you need non SAP DB ?

Amar

kr_pavankumar
Contributor
0 Kudos

Hi Amar,

Let me put it this way.

SQL -- SLT -- HANA.

SQLHANA is the schema configured for SQL. A table called ZSALES  was created under SQLHANA schema and has some data. Now, data needs to be replicated from a table ZSALES which in on SQL to HANA table which is already existing i.e., ZSALES and contains data.


Is it possible to replicate data to an existing table? Any workaround? Thanks!

--

KRPK

0 Kudos

I believe it is possible to use the same table if the structures are same. There is an option in LTRS table settings for this.

Former Member
0 Kudos

Hello Pavan,

Assumption : SQLHANA Schema you mentioned is avaialble in HANA and Zsale table is part of that schema..

Simply start the replication of thew table it will go through

amar