Salesforce CPQ data deployment entails the seamless transfer of CPQ object's data from one Salesforce CPQ Org to one or multiple other Salesforce CPQ Orgs. Following meticulous testing and approval of data modifications within a designated Sandbox or Development Org, these changes can be seamlessly transitioned to Test and User Acceptance Testing (UAT) Sandboxes, and finally, into the production environment, leveraging the powerful automation of FlexDeploy. This entire process is orchestrated with meticulous attention to detail, including obtaining necessary approvals and adhering to stringent quality gate criteria.
FlexDeploy facilitates seamless data deployment for both Cross-Reference and Self-Reference CPQ objects.
With FlexDeploy, you can bundle numerous data files (objects) into a single package, enabling the migration of data from multiple, distinct objects in one go, simplifying the process of moving data from one organization to another.
Flexibility to establish a specific sequence for deploying these objects data, ensuring precise control over their deployment order.
Creating sets of Data File Types, often referred to as templates, allows you to migrate data as a group, preserving and maintaining the hierarchical (parent-child) relationships between records.
The Project Setup in FlexDeploy is the same for code and data deployments. Create a new project for Salesforce or use an existing Salesforce project to start migrating your Salesforce CPQ data. Check our Salesforce Tutorial if you did not create a Salesforce project to start with.
Before diving into the data deployment process for CPQ objects, it's crucial to establish the required configurations in both Salesforce and FlexDeploy. This comprehensive setup process lays the foundation for a successful data deployment. Refer our Salesforce Data Deployments Tutorial for comprehensive information on data deployment, including details about setting up data deployment using FlexDeploy, creating packages and data files, understanding the concept of External IDs, and more.
Before you get started, you should be familiar with the Salesforce CPQ Objects and its Relationships, Object Dependencies, External IDs, Security Settings, etc.
Data Deployment - Bidirectional Lookup Relationship (⇌)
A Bidirectional Lookup Relationship (Cross-Reference) in Salesforce represents a special type of relationship between two objects where each object can reference the other using a Lookup field. This means that two objects are related to each other in a bidirectional or two-way manner. This Cross-Reference object's data deployment ensures that complex relationships and dependencies between CPQ objects, such as products, price books, and quotes, are maintained accurately in different environments.
Steps to Deploy Cross-Reference Object’s Data:
Create a Package in FlexDeploy as you would normally.
Make a list of all the objects (having cross-reference) data files you would like to migrate. For Eg., Opportunity ⇌ Quote
a. Opportunity have a 'lookup' or reference to Quote, and conversely, Quote have a 'lookup' or reference with its parent Opportunity. This establishes a bidirectional or two-way linkage between these two objects.Use Create button to Create a new data object template file to migrate (build and deploy). Start creating with the top-level object data file which is Opportunity in this case and repeat the same step for Quote. You can adjust sequencing if got created in the wrong order.
Create Opportunity Object Data File:
a. Select Operation type - Insert (for creating records)
b. Select the Object - Opportunity
c. Select all the columns (fields) you would like to migrate, except SBQQ__Quote__c [Reference] field
d. Click Save
Repeat the same steps to create Quote Object Data File. In this step, select all the all the columns (fields) you would like to migrate including Opportunity [Reference] field.
Now, create another Opportunity Object Data File: (In this case, we will update the SBQQ__Quote__c reference field)
a. Select Operation type - Update (for updating records)
b. Select the Object - Opportunity
c. Select only SBQQ__Quote__c [Reference] and External ID fields (columns)
d. Select the External ID, ensuring it matches the configuration in the project properties and is also selected in the Column Names selection in #c.
e. Click Save
All set! Your package is ready for build and deployment whenever necessary. You can repeat the build to get fresh data updates for the same set of files and fields.
Data Deployment - Self Lookup Relationship (↺)
A Self Lookup Relationship (Self-Reference) in Salesforce refers to a relationship type where records within the same Salesforce object can be linked or related to one another. Unlike traditional relationships in Salesforce, which connect records in one object to records in another object, Self Lookup Relationships allow records within the same object to establish connections. This can be particularly useful for modeling hierarchical or self-referential data structures.
Steps to Deploy Self-Reference Object’s Data:
Create a Package in FlexDeploy as you would normally.
List out all the objects (having self-reference) data files you would like to migrate. For Eg., Contact ↺
a. Contact object is linked to itself through a 'lookup' or self-reference, creating a self-referential connection within the Contact object.Use Create button to Create a new data object template file to migrate (build and deploy).
Create Contact Object Data File:
a. Select Operation type - Insert (for creating records)
b. Select the Object - Contact
c. Select all the columns (fields) you would like to migrate, except Contact [Reference] field
d. Click Save
Now, create another Contact Object Data File: (In this case, we will update the Contact reference field)
a. Select Operation type - Update (for updating records)
b. Select the Object - Contact
c. Select only Contact [Reference] and External ID fields (columns)
d. Select the External ID, ensuring it matches the configuration in the project properties and is also selected in the Column Names selection in #c.
e. Click Save
All set! Your package is ready for build and deployment whenever necessary. You can repeat the build to get fresh data updates for the same set of files and fields.
