Oracle Transactional Business Intelligence
OAC - SaaS Data Replication Functionality Capacity
Content
Hi Team,
is there any limitation to row count to be extracted via OAC - SAAS Data replication functionality.
We are planning to bring data from Oracle SaaS Fin, CX, isupplier, mfg & 2 other modules and build a ODS & DWH out of it using ADW. DO you see any limitation or challenge for replicating data for almost 350+ PVO's having daily transaction of around 5 Million all combined.
Version
OAC 5.8+
Comments
-
I'm not sure about the SAAS Data replication functionality but yes there is a restriction for OAC, this is dependant on the number of OCPUs, I believe you can export 500,000 rows from 2-15OCPUs for example
-
Hi Richard,
Thank you for your post,
Point you have mentioned is more about, while exporting data using DV or answers into CSV, excel or any other export available.
my query is more around using data replication functionality available in OAC - see URL for details - https://www.ateam-oracle.com/saas-data-replication-in-oracle-analytics-cloud-oac-and-oaac
