cancel
Showing results for 
Search instead for 
Did you mean: 

SLT for source and target, both non-SAP

NirmitShah
Explorer
0 Kudos

hi SLT gurus,

We are analyzing the option to migrate data from on-premise db into on-cloud db using SLT. Both the source and target are non-SAP and this will be a one time migrations with virtually no transformation needs.

This seems technically feasible given that SLT is compatible with both db - notes below.

However, I will appreciate if the gurus can share their thoughts on feasibility and risks involved. Given that our Source db is on mainframe, we do not have too many options for replication tool.

I have read ample notes/blogs but all of them have HANA/SAP on either side of the equation.

1768805

1778975

Accepted Solutions (1)

Accepted Solutions (1)

Andrey_M
Advisor
Advisor
0 Kudos

SLT has no restrictions for replication from DB to DB. Only things that you have to have enough premissions on both side to perform corresponding opertations (see the security docu). Sometimes it's a problem to get such authorizations in cloud db.

Answers (2)

Answers (2)

Andrey_M
Advisor
Advisor
0 Kudos

Hi Nirmit,

1. Yes, you assumption is correct: if you don't activate NULL replication in configuration, then of course the initial values will be transfered into target.

2. Also true

3. Also true

For question 2 and 3 SLT has no workaround. Regarding question 1, if you install the lastest version of SLT you can activate NULL value replication. Then you can transfer NULL values as well

NirmitShah
Explorer
0 Kudos

Thank you for your response Andrey. I have found several restrictions in 1768805 of which following are concerning in that order.

1. Null Values cannot be replicated if the target is non-HANA - Does this mean SLT will transform NULL to 'intial' depending on the data type? e.g. 0 for NULL Integer, '' for NULL Char etc.

2. Only elementary data types are supported

3. Trailing spaces will get truncated

I will greatly appreciate if you can share implications or work around on the concerns.