Integration Process - Non csv format
Steps for the integration process for non csv format is described below
Procedure
- Use the appropriate Cast Iron activity to load a sample data set into an orchestration
- Use the Flat File schema editor to convert the data to CSV
- Write the sample data to a CSV file using an FTP activity
- Create the metadata JSON file for the data that is to be loaded to Analytics Cloud
– Use the Salesforce tools- – Use the IBM TIP– Manually create the file
- 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 file data
- Use the Create Dataset activity to map the name, metadata and status
- Use the Load Data activity to map the file data and load the data to Analytics Cloud
- Use the Update Dataset activity to set the processing status
- Use the Retrieve Dataset activity to poll Analytics Cloud for the status of the data load