A customer has custom data warehouse built in MS SQL server that they are using with multiple internal systems for reporting purposes. When using IFS Cloud they want to keep using the same data warehouse solution.
What is the best way of loading data to their existing data warehouse from IFS Cloud at the database level?
Is it possible to use Access Views for this purpose? if so are there any benefits of using access views for this rather than using Oracle views with direct DB connection?