Oracle Communities

Oracle Analytics and AI

Child Item

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.

Find more posts tagged with

Archived

Extensibility

CX Analytics Content

Extensibility and Data Connectors

Fusion CX Analytics

data augmentation

Status: Archived

Comments

User_6BZ3R

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

Jamie Anderson-Oracle

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.

User_6BZ3R

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-0000768672