You can use the Salesforce catalog source to extract metadata from a Salesforce source system.
Salesforce is a cloud-based platform that integrates Salesforce CRM, Salesforce Data 360, and Salesforce Flows applications for customer service, analytics, and automation.
Extracted metadata
You can extract specific metadata from a Salesforce source system with a Salesforce catalog source.
Metadata Command Center extracts metadata of the following objects from a Salesforce CRM application:
•Organization
- List View
▪ List View Column
- Trigger
- Salesforce Object
▪ Field
Note:
If there is a duplicate global list view that is not associated with a specific object in the source system, then only one global list view is extracted.
Metadata Command Center extracts metadata of the following objects from a Salesforce Data 360 application:
•Organization
- Data Lake Object
▪ Data Lake Object Field
- Data Space
▪ Calculated Insight created with Visual Builder or by SQL authoring
▪ Dimension
▪ Measure
▪ Data Mapping linked to Data Model Object
▪ Data Model Object mapped and used within a Salesforce Data 360 application
▪ Data Model Object Field
▪ Identity Resolution
▪ Match and Reconciliation
- Data Stream
▪ Data Stream Calculation including Formula Field and Filter
- Data Transform
▪ Batch Data Transform and Streaming Data Transform including Data Transform Definition
Metadata Command Center extracts metadata of the following objects from a Salesforce Flows application:
•Organization
- Flow
▪ Autolaunched Flow (No Trigger)
▪ Data 360-Triggered Flow
▪ Record-Triggered Flow
▪ Schedule-Triggered Flow
Note:
You can only extract metadata of the unmanaged flows.
Data profiling for Salesforce objects
Configure data profiling to run profiles on the metadata extracted from a Salesforce source system. You can view the profiling statistics in Data Governance and Catalog.
You can run data profiles on metadata extracted from the following Salesforce CRM objects:
•Organization
- Salesforce Object
You can run data profiles on metadata extracted from the following Salesforce Data 360 objects:
•Organization
- Data Lake Object from the default data space
- Data Space
▪ Calculated Insight created with Visual Builder or by SQL authoring
▪ Data Model Object mapped and used within a Salesforce Data 360 application
Note:
When you run data profiles on unmapped Data Model Object fields, the results display empty values.
The data profiling task runs profiles on the following data types from Salesforce CRM applications:
•ANY TYPE
•BOOLEAN
•COMPLEX VALUE
•CURRENCY
•DATE
•DATETIME
•DOUBLE
•EMAIL
•ID
•INT
•JSON
•LONG
•MULTI PICK LIST
•PERCENT
•PHONE
•PICKLIST
•REFERENCE
•STRING
•TEXT AREA
•URL
The data profiling task runs profiles on the following data types from Salesforce Data 360 applications:
•BOOLEAN
•DATE
•DATETIME
•EMAIL
•NUMBER
•CURRENCY
•PERCENT
•PHONE
•TEXT
•URL
Compatible connectors
Before you configure a Salesforce catalog source, you must connect to the Salesforce source system.
Use the Salesforce connector to connect to the Salesforce source system.
To run data profiling and data quality jobs on objects extracted from a Salesforce Data 360 application, use the Salesforce Data 360 connector.
Note:
The Salesforce Data 360 application integrates data through connectors. You can use the application with the ingestion API connector.
For information about configuring a connection, see Connections.