Oracle Sales Cloud is a powerful tool for managing customer relationships, but extracting data from it for use in custom applications can be a challenge. In this blog, we explore how to efficiently extract data using Oracle Data Transforms and BICC (BI Cloud Connector), ensuring smooth integration with external applications.

 

Why Extract Data from Oracle Sales Cloud?

Businesses often need to integrate Sales Cloud data with other applications for advanced analytics, reporting, and automation. Oracle Data Transforms provides a robust mechanism for efficiently handling data extraction while maintaining data integrity.

 

sales-cloud

 

Step-by-Step Guide to Data Extraction

1. Preparing Oracle Data Transforms & BICC Configuration

Before extracting data, ensure that:

  • Oracle Data Transforms is properly set up.
  • BICC connection is configured to interact with Sales Cloud.

Once these prerequisites are met, proceed with adding the API name as a Public View Object (PVO) in BICC.

2. Creating & Populating the Custom Application 

To demonstrate the extraction process, a sample grievance form was created in Sales Cloud:

  • Navigating to the custom application.
  • Entering sample data to test extraction.
  • Setting up a sandbox to identify and interact with custom objects.

3. Configuring a Custom Offering in BICC

  • Create a custom offering in BICC.
  • Add the API name to the data store.
  • Select relevant columns and configure filters.
  • Save and test the connection to ensure successful integration.

4. Setting Up Oracle Data Transforms

  • Establish a connection to BICC within Oracle Data Transforms.
  • Import the necessary data entities from BICC.
  • Choose the CRM Analytics schema and link it to the custom offering.
  • Execute a job to extract metadata and reverse-engineer the data flow.

5. Creating & Running a Data Flow for Extraction

  • Create a data flow in Oracle Data Transforms.
  • Define the source and map columns from BICC to target tables.
  • Run the data flow to extract and store the data in Oracle ADW (Autonomous Data Warehouse).
  • Validate the extracted data in SQL Developer.

 

Conclusion

Oracle Data Transforms, combined with BICC, provides a powerful way to extract and integrate Sales Cloud data with external applications. By following these steps, businesses can enhance their data driven decision making processes.