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

[akhileshkiran]

Hi bvasu.reddy,

If you are looking to execute the Lookup batch job - Job_DM_Lookups_FileToApp batch job. I see these are import tables in the target.

In RDS packages we have two data stores configured like DataStore_Name_LKP and another with DataStore_Name_LKP_INIT.

DataStore_Name_LKP_INIT - DataStore will be holding the Template Tables.
DataStore_Name_LKP - DataStore will be holding the Imported Tables of the Template Tables.

If you are unable to find the tables in the database, then you are running the wrong job.

By looking your screenshot, I am assuming that you are running the Job_DM_Lookups_FileToApp first.

f I look into the data flow, Those are imported tables pointed to DS_STG_MGMT_LKP.

EG : LOOKUP_RUNTIME_FILETOAPP(DS_STG_MGMT_LKP.DS_OWNER)

If I check this table in the LKP_INIT data store, It is being called in the Job_DM_Lookups_Initialise batch job.

If you run this batch job, then all the lookup tables will be created in the database.

I request you to please recheck and reconfigure the files path and the directories permissions to for the flat files.

Thanks & Regards,

Akhilesh Kiran N.

[former_member384249]

Hi Akhilesh,

Thanks for responding, actually i executed Job_DM_Lookups_Initialise first then only i started with Job_DM_Lookups_FileToApp.

I have re executed the initialise job and its finished with warning of Replace_Substr_Max_Size_Characters parameter in DSConfig.txt

Again re executed the Job_DM_Lookups_FileToApp its throwing same error.

If you see tables starting with LKP_* under the data store of MGMT_LKP those are not visible in backend database of SQL Anywhere, actually i am not sure that issue with SQL Anywhere database or Data service lookup jobs are causing it.