Integration Process - Non csv format

Steps for the integration process for non csv format is described below

Procedure

  1. Use the appropriate Cast Iron activity to load a sample data set into an orchestration
  2. Use the Flat File schema editor to convert the data to CSV
  3. Write the sample data to a CSV file using an FTP activity
  4. Create the metadata JSON file for the data that is to be loaded to Analytics Cloud

  5. – Use the Salesforce tools
  6. – Use the IBM TIP– Manually create the file
  7. Load the JSON file into the Cast Iron project as a default value in a string variable
  8. Use the appropriate Cast Iron activity (HTTP, FTP, etc ) to receive the file data
  9. Use the Create Dataset activity to map the name, metadata and status
  10. Use the Load Data activity to map the file data and load the data to Analytics Cloud
  11. Use the Update Dataset activity to set the processing status
  12. Use the Retrieve Dataset activity to poll Analytics Cloud for the status of the data load



Feedback | Notices


Timestamp icon Last updated: Thursday, December 17, 2015


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