DW custom schema

Posted by Laurel on Nov 21, 2024; 10:33am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/DW-custom-schema-tp12764.html

Hi  Dear Erman!
Questions :)
We have 12.2.8 EBS and now there is project for Datawarehouse cloud where they massload all financial data. The  business logic will be in DWarehouse.

Options:
a) custom user  in EBS xxdwh  and select only  access to the bunch of  fina tables required

b) custom user in EBS xxdwh  and create apps.xx_customviews that will do select * from the base tables ( like apps.xx_ap_invoices as select * from ap_invoices_all)
create synonyms for the xxdwh user for those views
and grant select only  access to those views apps_xx_customviews  the xxdw..


For me option a) is more straighforward and no extra views in APPS schema ... I think option a) would be better for performance as well than b)


Q2)
for the cloud connections to db i was thinking that  we need to create a new db listener with TLS enabled,
as the inhouse EBS itself  we use db listener  port 1521 TCP without TLS .

2 listeners on db tier  with TLS and not TLS should be possible/supported  in  EBS ?  Need only custom IFILE  manually configured  for the custom listener. Any pointers  to  documents how to do it would be appreciated :)

What are your reccomendations ?
Thx alot! :)
best wishes,Laurel