Use case with CSV format data
Steps for the integration process for simple csv format is described below
Procedure
- Use the Salesforce tools or manually create the metadata JSON file for the data to be loaded onto Analytics Cloud
- Load the JSON file into the Cast Iron project as a default value in a string variable
- Use the appropriate Cast Iron activity (HTTP, FTP, etc) to receive the CSV data
- Use the 'Create Dataset' activity to map ' EdgeMartAlias ' and 'Operation'. Specify 'Format' to be 'CSV'. Base-64 encode the JSON and map to ' MetadataJson '
- 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'
- Use the 'Update Dataset' activity to set the 'Status' of the dataset to 'Process'
- Use the 'Retrieve Dataset' activity and poll Analytics Cloud for the status of the data load