Skip to Content
0
Oct 14, 2021 at 06:09 AM

How can i migrate a SQL View from Oracle database to a new View in SAP DWC

185 Views Last edit Nov 11, 2021 at 11:59 AM 2 rev

Hello,

I have a scenario where my current datamart is in Oracle database which we need to migrate to SAP DWC Platform.

The Key objects in Oracle database are Dimension Tables, Fact Tables and SQL Views(combining Dimension and Fact tables) for reporting.

I understand that I can connect to Oracle Tables remotely or import them in SAP DWC to persists and schedule the refresh at a required frequency.

My key concern is how do i migrate the SQL Views from Oracle database which has all my business logic into SAP DWC without manually recreating these views in SAP DWC