Connect OAC directly to Oracle CPQ Cloud

AnkitR Gupta

Summary:

Hi Experts, we are looking for options to show some realtime data from CPQ into OAC dashboard. This will allow users to see, open orders or quotes and then users can take actions accordingly.

let us know if there are any ways to connect CPQ to OAC.

Also, like fusion cloud application, does CPQ cloud have OTBI ?

Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

SiddharthDang-Oracle

Dear Ankit,

Currently, the recommended way to extract data from CPQ is using data cube extract. It will extract data in a remote SFTP server in the form of a text file. Use any ETL/ELT tool to inject into a data warehouse. Check out the doc on oracle support to help you further. -> How To Set Up a Data Cube Export (Doc ID 1660632.1)

Regards,

Siddharth Dang

prakashj

Oracle only allows 4-5 data cube export from the CPQ cloud. So, the process would still be a batch. Data cube export is essentially a SQL loader file that can be loaded to ADW or oracle database.

If you are using ADW or Oracle DW as the target, you can potentially create REST api on ADW. Leverage CPQ integration server capability to push real time changes to that end point . You can then parse the XML data in pl/sql or other tools to make it available for reporting.

hth,

Prakash

Waleed Fetoh

Any update in this matter?

SteveF-Oracle

List of Supported Data Sources in Oracle Analytics Cloud

GayathriAnand-Oracle

Another option is to get Fusion Data Intelligence (FDI) which offers support for data augmentation using cpq connector and build visuals in OAC (Which comes with FDI). Check details of setup here: https://www.ateam-oracle.com/post/transforming-oracle-cpq-data-into-insight-with-fdip

Bhaskar Konar

Very helpful information.

Thanks for sharing guys!