Data services using Rapid Data migration

[former_member384249]

Good Day All,

for S4HANA Migration using Data services i have few questions below, Could you please clarify for me.

1. Can we use Database SQL Anywhere 17 for RDM (Rapid Data Migration)
2. Can we do migration to S4HANA using data services without using RDM package

Basically i am trying the RDM package with SQL Anywhere database but my Lookup jobs are getting failed, i have tried to manage successful initialization of job Job_DM_Lookups_Initialise but Job_DM_Lookups_FileToApp getting failed and its throwing the below error.

when i tried check backend sql anywhere database those LKP_* tables are not showing.

Could you please assist on the above points,

Regards,

Sreenivas

[Julian_Riegel]

Hi, the error message has not been attached - could you resubmit your screenshot?

In case you have connected your target system already, have you tried executing Job_DM_Lookups_SAPToApp.

As per RDM Quick Guide:

Use one of the following databases:

SAP HANA 1.x or above

Oracle 12c

Microsoft SQL Server 2008 R2

IBM DB2 v9.7

Sybase ASE 15.7

For Data Quality Package, Database SAP HAHA 1.X and Sybase ASE 15.7 is out of scope

2. Yes you can, this would require some more manual developments for sure. An Option would be mentioned in following blog:

https://blogs.sap.com/2021/03/10/part-1-migrate-your-data-migration-cockpit-from-sap-s-4hana-2020-sa...

You can use SAP Data Services to populate the staging tables of the Migration Cockpit.

[former_member384249]

Hi Julian,

Thanks for responding me, Basically we have set upped DB SQL Anywhere 17 version for Data services, As part of RDM i have downloaded .ATL files and started lookup jobs execution that's only Initialize and FiletoAPP jobs,

for the filetoapp job execution i am getting below error attached

After my investigation i found that all LKP_* tables are not sitting in SQL Anywhere database but if i look in data store of DS_STG_MGMT_LKP i can see all tables under it and that data store connection pointing that SQL Anywhere 17.

I am wondering why those tables not showing in backend DB, if anything need to be done, could you please assist on that.

[former_member822352]

i am facing failure in saptopp job -- it shows failure that "no lookup table found in lkp_runtime_saptoapp" [below snapshot]

i have imported DM_BPFDM_Lookups project, then updated the datastore for my sap S4 target and my staging dbs [our staging db is oracle]. i run the initialize job --- all tables loaded with 0 records

next i run the saptopp job -- it shows failure that "no lookup table found in lkp_runtime_saptoapp" [below snapshot]

[Former Member]

I saw your posted comment. I recommend raising your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. Feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you'll be able to prepare questions that draw responses from our members.

Thanks!