SLT From ABAP source to SQL server, is transport needed?

[pablo_leonel]

Hi all.

I'm handling a new configuration that involves.

ABAP - SLT - SQL server

At this time I have created the proper entry in LTR and LTRC transaction, on my Development system. (even though the lack of documentation about this scenario)

we run on DMIS 2011 SP11, so this scenario is perfectly covered.

I was wondering which is the procedure to implement Start loads or replication in Quality system or Production due to SLT configuration seems to create Logging tables and transformation rules in the SLT side, that cannot be recreated on a closed system.

As far I know there is no needed, but I guess this situation affects users on HANA or any destination.

also, I'm looking for information about what objects are created and where (Source or SLT system?) on each replication.

Transparent tables , Logging table, runtime objects, function group, and more

I really appreciate your help or documentation about this.

thanks in advance

[thirunavukarassu_saravana · Accepted solution]

Nothing needs to be transported in normal scenarios. Below are the steps for adding a table for initial load/replication

1) The replication settings need to be maintained in LTRS, which can be done even when the system is closed. But it is good to have the replication settings consistent across dev, qa & prod. So I would suggest to make the settings in Dev, then export and import it into QA & Prod. There is an option in LTRS to export the settings using a file and import it into another system.

2) Add the system with Start Load/Replication (as per the need) in LTRC. This would create the triggers & logging tables in the source system (ABAP) and load/replicates the data.

In case if you use any programs for rules transformation that is maintained in LTRS, then you need to transport that program before doing the above 2 steps.

[Former Member · Accepted solution]

Hi,  we are loading data from ECC to SQL using SLT, We run on DMIS 2011 SP10, The target tables are created successfully in SQL, but the data is not loading,

Errors:

aborted due to SYSTEM FAILURE

A table is unknown or does not exist (During execution of an RFC an system- or communication error has occured)

Execution of program /1CADMC/OLC_100000000001431 failed, return code 3 (Error writing the data)

Are there any specific SLT - LTRS settings for the non-SAP receiving systems?

thanks for your kindly help.

.

[pablo_leonel · Accepted solution]

NO really.

the tables were created automatically by slt or manually¿