You are here:
Salesforce CRM Analytics Connector
The Salesforce CRM Analytics Connector by Mulesoft establishes a connection to the External Data API for TPE.
Salesforce CRM Analytics Connector can insert data into CRM Analytics by connecting to an existing dataset or creating a new dataset.
- Connecting to an Existing Dataset: Connecting to an existing dataset from MuleSoft requires
a dataset ID. To fetch the dataset ID from Salesforce, use the following SOQL query:
Select id,EdgemartAlias,EdgemartContainer,EdgemartLabel,Status,Action,isDeleted, StatusMessage,LastModifiedDate from InsightsExternalData where EdgemartAlias =“Dataset Name”order by LastModifiedDate descFollow the most recent entry only from this SOQL query.
- Creating a New Dataset: Creating a new dataset requires a metadata.json file that describes the structure of the external data object. For more information, see Using Datasets to Connect Your Data

