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

[former_member746991]

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

[RonaldKonijnenb]

Hi,

Its SQL, slightly different accent between Oracle and HANA, but you have a great start. I would jump on this. Fun project.