Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to Extract Data From Custom DATA TABLE objects in CPQ
We have Data stored in CPQ Data tables . These are Custom tables. We would like to load this data into ADW using Data Augmentation. Even though we can create connection to CPQ, Oracle does not support data augmentation from Custom Data Tables on CPQ.
We need the CPQ bulk data extract API and FDI CPQ connector to be enhanced to support extraction of information from CPQ Data table to FDI - CX.
Based on the discussion with FDI CX PMs, the API/Connector currently doesn’t support extraction of data tables.
This is a critical requirement for MBI Inc's reporting needs as we can't leverage Out of the box FDI subject areas since we are adding Historical Data. The ability to extract from DATA TABLEs will ease the work.
Comments
-
This idea is similar to an existing request:
https://community.oracle.com/products/oracleanalytics/discussion/23007/support-for-extracting-data-from-cpq-data-tables-using-cpq-bulk-extract-api?utm_source=community-search&utm_medium=organic-search&utm_term=CPQ+DataTable
0 -
Hi @User_6BZ3R - can you please raise an SR for this idea? You should be able to connect to any table, but if you are having issues, the Support team can work through this with you.
0 -
Hi @Jamie Anderson-Oracle Thanks for your input. This idea was logged based on suggestion from Product Management team. They were involved in the SR I had raised for this issue. @Pinaki Sahoo-Oracle can provide some inputs on this.
This is the SR: 4-00007686720
