SOH DB Migration

[Former Member]

Hi All,

Once the ECC DB is migrated to SOH. I have following questions:-

1. Do all the tables in ECC get converted to Cloumn store so that they can be used in Analytical views. Or they still remain as Row store tables for a faster commit. If yes do we need to configure SAP SLT server to replicate the ECC tables to another Schema where we convert the tables into Column store and use it for realtime reporting through Analytical views. What i see is that when you create a table in SAP HANA as a row store you cannot use it in an Analytical view for reporting.

regards

Nilesh

[former_member182967]

Hello Nilesh,

As Erich mentioned in

All row tables (VBRK) converted to column tables?

Yes, all row tables which contain transaction data will be converted. Most Meta data tables like customizing tables stay in row format.

Regards,

Ning Tong

[Former Member]

Thank you Ning,

So we need not replicate the ECC tables to a different schema using SLT and convert them into column store. We can use the same tables for Analytical reporting.

Regards

Nilesh

[former_member182967]

Hello Nilesh,

For 'business' data table, no need to convert.

In theory, they can be used. I suggest you to consult with your analytical consult to get the confirmation..

Regards,

Ning Tong