We have a requirement to move the API from CRM to HANA. During analysis we have found out that there are a lot of dictonary tables involved in API including marketing attributes, address, services, oneorder documents, items, products. Our plan is to replicate these tables and then expose the required aggregated data via OData Service.
What is the best way to replicate these tables in the above scenario? SLT?
During replication of CRM dictionary tables do the foreign keys get kept or we need to manually reconnect all the related tables?
In API there are a lot of dictionary objects involved that we are not aware of what is the best technique to identify those?
We are hoping for a solution that allows for this scenario to replicate the whole data model.