Use case with XML format data

Steps for the integration process for XML data format is described below

Procedure

  1. Use the Salesforce tools or manually create the metadata JSON file for the data to be loaded onto Analytics Cloud
  2. Load the JSON file into the App Connect project as a default value in a string variable
  3. Use the appropriate App Connect activity (HTTP, FTP, etc) to receive the XML data
  4. 1. Use the 'Create Dataset' activity to map the ' EdgeMartAlias ' and 'Operation'. Specify 'Format' to be 'CSV'. Base-64 encode the JSON and map to MetadataJson
  5. 1. Serialize the XML data using the 'Write XML' activity. Refer Example 1: How to Configure the Write XML Activity for XML Data on how to configure this activity to serialize the XML correctly
  6. Use the 'Load Data' activity to map the ' InsightsExternalDataId ' and ' PartNumber ' (optional). Base-64 encode the XML and map to ' DataFile '. Specify ' DataFormat ' to be 'XML'. This will configure the the connector to internally convert the XML to CSV and invoke the SFDC Analytics API with the CSV
  7. Use the 'Update Dataset' activity to set the processing status Refer the topic " How to configure the Write XML Activity for XML Data "
  8. Use the 'Retrieve Dataset' activity to poll Analytics Cloud for the status of the data load



Feedback | Notices


Timestamp icon Last updated: Tuesday, 27 September 2016


http://pic.dhe.ibm.com/infocenter/wci/v7r0m0/topic/com.ibm.wci.doc/Salesforce_analytics_connector_UseCase_xml.html