Use case with CSV format data

Steps for the integration process for simple csv 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 Cast Iron project as a default value in a string variable
  3. Use the appropriate Cast Iron activity (HTTP, FTP, etc) to receive the CSV data
  4. Use the 'Create Dataset' activity to map ' EdgeMartAlias ' and 'Operation'. Specify 'Format' to be 'CSV'. Base-64 encode the JSON and map to ' MetadataJson '
  5. Use the 'Load Data' activity to map the ' InsightsExternalDataId ' and ' PartNumber ' (optional) Base-64 encode the CSV and map to ' DataFile '. Specify ' DataFormat ' to be 'CSV'
  6. Use the 'Update Dataset' activity to set the 'Status' of the dataset to 'Process'
  7. Use the 'Retrieve Dataset' activity and poll Analytics Cloud for the status of the data load



Feedback | Notices


Timestamp icon Last updated: Wednesday, 15 June 2016


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