Data Productivity Cloud Pipeline

Use this Quickstart Data Productivity Cloud pipeline to generate an integrated report from the Account, Contact and User Salesforce tables.

Salesforce tables used

Referring to the Salesforce Architects Sales Objects reference:

Image ofSalesforce Entity Relationship Diagram
Salesforce Entity Relationship Diagram

Integrated report table

Output table: mtln_qs_sf_accounts_with_contacts

Granularity: One record per Contact

Generating the report

Start by opening the Orchestration pipeline:

Image ofOrchestration pipeline qs-sf-accounts-with-contacts-orch
Orchestration pipeline qs-sf-accounts-with-contacts-orch

Set the default value of the pipeline variable SalesforceOAuthName to the name of your Salesforce OAuth.

Run the Orchestration pipeline. It will sync your Salesforce data, and create the output table using the Transformation pipeline.

Image ofTransformation pipeline qs-sf-accounts-with-contacts-tran
Transformation pipeline qs-sf-accounts-with-contacts-tran

Customization

Downloads

Licensed under: Matillion Free Subscription License

Download qs-sf-accounts-with-contacts-orch.orch.yaml

Download qs-sf-accounts-with-contacts-tran.tran.yaml

Installation instructions

How to Install a Data Productivity Cloud Pipeline

Author: Matillion