Leverage Mulesoft for Data Integration

To set up data integration using Mulesoft:

• Understand Data Source: Ensure that the data (Promotions, Promotion Tactics, and Account Plan Data) exported from TPM is in CSV format. The CSV file export for a configured integration metadata report is initiated with endpoints provided by the RTR gateway.
  

  Note To avoid errors when creating dashboards and widgets, do not use the same labels for multiple KPIs when configuring the KPI definitions.
• Download and configure MuleSoft Accelerator for Consumer Goods (TPE APIs)
  • RCG Data Normalization Process API
    • Exports Data from Hyperforce
      • Configure a scheduled job that triggers APIs to export data from Hyperforce
      • Configure business objects for Promotion, Promotion tactic, Account plan, and Exported measure codes including datasetPrefix, objectPrefix, metaName, businessYear, salesOrg, datasetName, and recipeDatasetPathway
    • Converts data into the required format for CRM Analytics
    • Export Data to CRM Analytics: Leverages Salesforce CRM Analytics Connector to import data to CRM Analytics
      • MuleSoft converts the CSV data as per CRM Analytics requirements. The External Data API uploads .csv files, and you can optionally specify the structure of your data by defining metadata in JSON format.
        

        Note The data and metadata files are used to populate a dataset with the external data. For more information on formatting CSV data and JSON metadata, see the Analytics Extended Metadata (XMD) Developer Guide.
    • Triggers the Recipe API on the dataset pathway
    • Retrieves the File: After the CSV file is successfully downloaded by MuleSoft, it sends the Commit API to Hyperforce.
  • RCG Hyperforce System API
    • Configure host, credentials, client ID, and client secret for Hyperforce RTR classes
    • Checks the status of the job for Ready status in the Hyperforce System API at a configured frequency

• When the status of the job is Ready, the Data Normalization Process API invokes the Hyperforce System API to get the file in .csv.gz format.
• For more information on integrating Industries Cloud apps with external systems, see Industry Integration Solutions and MuleSoft Accelerator for Consumer Goods.