Integrate Oracle Commerce Cloud with CPQ Cloud and Leverage Autonomous Data Warehouse Analytics

With Oracle Integration, you can integrate your cloud and on-premises applications, automate business processes, gain insight into business processes, and develop visual applications—all in one place. Customers can achieve this integration by using application adapters, which simplify integration by eliminating the complexity associated with web services and other connectivity methods.

Oracle’s comprehensive library of application adapters provides a standardized way to rapidly connect the various protocols required by each application vendor. With application connectors for CX, ERP, and HCM, Oracle offers database, productivity, social, robotic process automation (RPA), and technology adapters.

Architecture

This architecture shows one example of this integration. Here, catalog items are imported to Oracle Commerce Cloud from an external source (third-party application) to offer promotions on those items. You can then use Oracle Configure, Price, Quote (CPQ) Cloud to complete the process from shopper inquiry, automatically applying discounts and relevant up-sell and cross-sell opportunities.

You can then upload the data to Oracle Cloud Infrastructure Object Storage and Autonomous Data Warehouse. You can use tools native to Autonomous Data Warehouse, such as machine learning and Data Science, and third-party tools to monetize the data for more business opportunities. Integrating these applications brings together the capabilities of Oracle Commerce Cloud and Oracle CPQ offering. This provides an end-to-end solution that enables businesses to offer shoppers a method of interacting meaningfully with the business during the purchasing process. It also provides agents with flexibility dealing with shoppers, improving their experience and maximizing shopper satisfaction.

The following diagram illustrates this reference architecture.

Description of the illustration integrate_oc_cpq.png

The architecture has the following components:

• Oracle Cloud Infrastructure Tenancy

  A tenancy is a secure and isolated partition that Oracle sets up within Oracle Cloud when you sign up for Oracle Cloud Infrastructure. You can create, organize, and administer your resources in Oracle Cloud within your tenancy.

• Oracle Cloud Infrastructure Region

  An Oracle Cloud Infrastructure region is a localized geographic area that contains one or more data centers, called availability domains. Regions are independent of other regions, and vast distances can separate them (across countries or even continents).

• Oracle Commerce Cloud
  An e-commerce solution that provides a range of powerful tools to build a flexible, feature-rich storefront. With Oracle Commerce Cloud, you have the following capabilities:

  • Customize the design and layout of your storefront pages and preview your changes
  • Display your store content in different languages
  • Create or import catalog items
  • Manage inventory and offer promotions
  • Manage shopper accounts and allow shoppers to set up wish lists
  • View reports about your store
  • Test the visual elements of your store to determine which design shoppers prefer
  • Develop custom features for your store through the Oracle Commerce Cloud web services AP
• Oracle Configure, Price, and Quote Cloud (CPQ Cloud)

  CPQ Cloud provides complete quote-to-cash process, from shopper inquiry to order fulfillment. It guides you to optimal product options and configurations from simple to complex, automatically applying discounts and relevant up-sell and cross-sell opportunities.

• Oracle Cloud Infrastructure Object Storage Buckets

  Object Storage provides quick access to large amounts of structured and unstructured data of any content type, including database backups, analytic data, and rich content, such as images and videos. Use standard storage for hot storage that you need to access quickly, immediately, and frequently. Use archive storage for cold storage that you retain for long periods of time and seldom or rarely access.

• Oracle Integration

  Oracle Integration is a fully managed service that allows you to integrate your applications, automate processes, gain insight into your business processes, and create visual applications. Oracle Integration for SaaS, a streamlined version of Oracle Integration, gives you the features and benefits of Oracle Integration, focusing on SaaS.

• Autonomous Data Warehouse

  An Oracle autonomous database that includes Oracle Machine Learning. Data scientists can build, evaluate, score, and deploy machine learning models using in-database Oracle Machine Learning features and the related Notebooks interface.

• Oracle Identity Cloud Service

  Oracle Identity Cloud Service provides identity management, single sign-on (SSO), and identity governance for a wide range of SaaS and on-premises applications.

• Cloud Guard

  You can use Oracle Cloud Guard to monitor and maintain the security of your resources in Oracle Cloud Infrastructure. Cloud Guard uses detector recipes that you can define to examine your resources for security weaknesses and to monitor operators and users for risky activities. When any misconfiguration or insecure activity is detected, Cloud Guard recommends corrective actions and assists with taking those actions, based on responder recipes that you can define.

• Oracle Cloud Infrastructure Identity and Access Management (IAM)

  Oracle Cloud Infrastructure Identity and Access Management (IAM) enables you to control who can access your resources in Oracle Cloud Infrastructure and the operations that they can perform on those resources.

Recommendations

Use the following recommendations as a starting point for integrating Oracle Commerce with CPQ SaaS Applications and the exporting data for analytics. Your requirements might differ from the architecture described here.

• Security lists

  Use security lists to define ingress and egress rules that apply to the entire subnet.

• Autonomous Data Warehouse

  Create a separate schema for exclusive use by data scientists. Grant the schema read-only access to the main data warehouse schema. This arrangement allows data scientists to create local views of data for exploration, analysis, and model building. Where needed, you can copy shared data into their own schema where data scientists can modify it locally.

Considerations

When integrating Oracle Commerce Cloud with CPQ Cloud and leveraging Autonomous Data Warehouse analytics, consider these implementation options.

• Service limits

  Consider the limits and quotas for the Oracle Cloud Infrastructure services used in the topology.

• Security

  Federating Oracle Cloud Infrastructure with Oracle Identity Cloud Service enables you to manage authentication and authorization for all the resources in the topology by using a centralized identity system. Note that depending on the date that your tenancy was created, it might be pre-federated with Oracle Identity Cloud Service.

• Cost considerations for Object Storage

  Use the low-cost Archive Storage service to store data that's rarely accessed but that must be retained for a long duration.

  Define lifecycle management policies to automatically move data to Archive Storage or delete data after a specified duration.

• Oracle Identity Cloud Service licensing

  A foundational license for Oracle Identity Cloud Service is provided with Oracle Utilities SaaS. You might need other features of Oracle Identity Cloud Service for more advanced identity management, such as federation, which requires additional licensing beyond what's provided with Oracle Utilities SaaS

Explore More

Learn more about integrating Oracle Commerce and CPQ SaaS applications and exporting the data for analytics.

Review these additional resources:

• Best practices framework for Oracle Cloud Infrastructure
• Understand Oracle Commerce Cloud Service
• Get Started Oracle CPQ Cloud
• Oracle Integration
• Integrating Oracle Commerce Cloud and Oracle CPQ Cloud