on 02-04-2013 12:28 PM
Hi There,
we want to create an application that replicating the SAP Data Source to another 3rd Party Database. As we stumbled upon the technology that introduced in the SAP LT Replication Server, we really keen to try this. However, we can't find a documentation regarding this issues. Is there a possibility to use the SLT to replicate data from SAP and targeting into another DB-System (non-Hana) ?
The question comes up, because the interface for accessing other Non-SAP Source is basically already there (however it is intended to load the data), so theoritically we can use the same interface to transfer the delta data with event based triggered.
Does anyone have an experience on this case ? It would be nice, if you can suggest a better approaches.
Thanks
Hi Ferry,
your are right, from a technical perspective this approach is possible, but we did not implement any Userinterface or E2E process so far. This topic is on our roadmap, but I cannot give any outlook by when it is ready.
If this is a hot topic for you and your landscape, we can discuss offline your scenario and needs, to see which option we have to help you. Just send me a mail.
Best,
Tobias
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tobias,
thank you for your reply
I want to accelerate the replication of the Data on the SAP ERP by CDC. There are already a legacy system based on Oracle. I need to download the delta data, triggered by the change in the ERP system. Therefore the SAP LT Replication Server seems so tempting.
I have also looked at the DXC, Sybase Replication, and CDC for RFC in ABAP. However, I can't find the simple solution like offered by SLT RS. Please correct me if I'm wrong. Or maybe you have any other suggestion and information that I've been overlooked.
Thanks again,
Ferry
Hello Tobias Koebler,
do you have an update for me related to SLT and non-HANA replication?
We want to replicate some ERP Tables from Oracle to MSSQL for example.
thx for your Help
Christian
Hello Tobias Koebler,
we want to replicate from SAP ERP to any kind of Database.
The goal is to minimize the Calculation impact on the productive database.
We want to use a preventive maintenance system which uses the database (oracle, mssql, maxdb) as source.
Best,
Christian
Hi,
to get your setup: You want to replicate from a SAP source via RFC over SLT to an other DB that do not run with a NW stack.
This setup is so far not integrated as an E2E solution, we have such scenarios on our roadmap - an planned earlierst Q1/2014. But we can think about such a scenario as project based solution. In gerneral the connection source->SLT is available but the connection to a non-HANA/BW target is not implemented.
If you would like to talk in more details - just send me a email and we can discuss your use case and evaluate if it is possible to implement a project based solution offline.
Best,
Tobias
Tobias,
Can you provide an update on this "planned ... Q1/2014" implementation? Is this available yet, is it still planned, timeline, etc.?
We have just migrated our BW System to HANA this past weekend. In our previous BW System on Oracle, we had a few BW Tables replicating using Oracle Database level Fast Refresh Materialized Views. These Mat. Views refreshed every 1 hr. These tables were replicated to two other Oracle Databases which use this data to support some Legacy Applications.
We are basically looking at possible solutions for implementing refreshing data from our new BW HANA Database to these Oracle Databases.
Note: The receiving Oracle Databases are not SAP Databases, they are Oracle Standard or Enterprise Databases supporting non-SAP Applications.
Thanks for any update/information you can provide.
Matt
Tobias, we are facing the same issue as discussed: "We want to replicate from a SAP source via RFC over SLT to another DB that do not run with a NW stack." However, instead of multiple DBs, we would just like to connect SAP data to GreenPlum. Can this be done by using data services adapter APIs? If so, could you name a few APIs that would be needed and a high level overview of how it can be leveraged? Thanks Rico
Hi Rico,
in general the replication to non-ABAP targets is not part of the product, but could be achieved for all NW supported DB's in an individual product. If the target is not a NW supported DB wen can think about putting DS into place. With SLT and DS 4.2 SP1 ther eis an integration that allows to esablish a connection between these two products and fill a target that is supported by DS.
Best,
Tobias
Hi Neha,
A lot of discussions have covered this topic.
SLT does support replication from non sap systems to HANA.
Please refer to below blog as a reference -
Hope this helps you!!
Regards,
Saritha K
Hi Tobias, I am trying to load a table from ECC to MSSQL and SLT is creating the target table in SQL successfully, but not writing data into the table and I can see an additional view in SQL for the target table.
Trying to debug the whole process, says a communication error, but the target tables are created w/o data.
errors:
Message no. DMC_RT_MSG041
During execution of an RFC an system- or communicationerror has occured.
In most situations the RFC is interrupted.
Analyse the reasons for this error by means of the error message and the system logs.
thanks again for your help!
Can anybody point to the current documentation or statement from SAP which target systems are supported?
(in transaction LTRC there is a drop-down-box for target database. Unfortunately the drop-down-box is grayed out. I can choose e.g. DB2 but the selected value switches back to HANA instantly)
Using DB-Connection
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thorsten,
You should have open new discussion.
Anyway, check if you have proper license for using non-sap targets.
If so and target is greyed out then check KBA 2285078.
You have to change entry in table DMC_RT_PARAMS:
Change the following entry:
PARAM_NAME = 'REPL_ENABLE_OTHER_TARGET'
PARAM_VALUE = 'X'
then Save.
Then create new configuration and select target.
Hope this resolve your issue.
Regards
BJ
Hi S J, I am trying to load a table from ECC to MSSQL and SLT is creating the target table in SQL successfully, but not writing data into the table and I can see an additional view in SQL for the target table.
Trying to debug the whole process, says a communication error, but the target tables are created w/o data.
errors:
Message no. DMC_RT_MSG041
During execution of an RFC an system- or communicationerror has occured.
In most situations the RFC is interrupted.
Analyse the reasons for this error by means of the error message and the system logs.
I haven't seen an option to select a target DB in LTRS, its is not in Table Settings
thanks again for your help!
What kind of issues are you having? Can you give some more details please.
Pawel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pawel.
Please see link below where i gave all details-
http://scn.sap.com/thread/3806972
I guess main issue is that we dont have TIMESTAMP data type in SAP. If you can have a look once.
thanks
Nilesh
To add a timestamp, you can simply go to LTRS, and in Rule Assignment, in line of code, type this code, assuming I want to add the timestamp into a field named ztime.
Field ztime should be type Char, length 15. You can add your field also in LTRS, in table settings.
Concatenate sy-datum sy-timlo into e_ztime.
Try that and it should work.
Yes Pawel we are able to send time stamp as varchar to oracle , however our requirement is to have it in oracle data type time stamp format which will make search easier when we fire query in oracle.
so we need to get oracle. Time stamp format inserted to oracle into date or time stamp data type, the main issue is sap does not have time stamp data type.appended time stamp field was defined as char in table settings and we are using mapping value tab to change char to time stamp data type in oracle.
YYour thoughts .
thanks
We never tried writing to Oracle in a timestamp field type. We use the varchar type in Oracle to write timestamps. But you're probably right that there is a format mismatch if you try it.
Have a look at this post, it mentions a few things about timestamps in abap:
I am doing a similar analysis. Essentially trying to understand how SLT replication to a non-SAP database could work. My understanding is that Data Services would be more of a batch scenario, essentially this would not support real time replication as SLT does. Ferry, did you have any luck figuring out how to do this via SLT?
Dan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We are facing the replicating the data to Oracle Database( Target DB). Below is the error found in trace file SM50
------------------------------------------------------------------------------------------------------------------------------------------
*** ERROR => Error -2 in stmt_execute() from oci_execute_stmt(), orpc=0
[dbsloci.c 18307]
C {root-id=0050569834521EE58DA44FC7A6ED6F1B}_{conn-id=55B7B7978B184062E1000000AC149EDF}_1
C *** ERROR => ORA--0002 occurred at SQL stmt (parse error offset=0)
[dbsloci.c 18308]
---------------------------------------------------------------------------------------------------------------
In SM21 we are getting Database Error -2 INS access to table /ILT/0000
SQL> SELECT GRANTED_ROLE FROM DBA_ROLE_PRIVS WHERE GRANTEE='BODSDATA';
GRANTED_ROLE
------------------------------
CONNECT
DBA
RESOURCE
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.