Story 1 - Mapping SaleForce to Google spread Sheet (XML --> CSV) Steps
1. Open Developer Studio and Create Maven Multi Module Project 2. User creates ESB Proxy service with ESB project inside the Maven Multi Module project 3. Add Google spread sheet connector operators (login,create spread sheet and create work sheet) into the proxy service. 4. Add Salesforce connector operators (Init and Query) into Proxy service. 5. Add data mapping mediator into the proxy service. 6. Double click on the data mapper mediator, then the "mapping configuration create dialog" will be opened. 7. User specify the mapping file name and create registry resource project to save the mapping configuration file.(Once user done this step, data mapping editor will be opened). 8. Right click on the input data container in the data mapping editor (left side white box in the editor), and import the input Avro schema (which was created according to Salesforce data structure 9. Right click on the output data container the data mapping editor (Right side white box in the editor), and import the output Avro schema(which was created according to Google spread sheet data structure) 10. Do the mapping by connecting input and output fields 11. Go back to the proxy service and add Google Spreadsheet connector operators(login,import csv) to the Proxy service. 12. Create Composite Application Project inside the Maven Multi Module Project 13. Add the Registry Resource Project and ESB project into Composite Project 14. Build the maven multi module project 15. Deploy the CAR in ESB sever 16. Invoke the proxy service. Above story will be demonstrated during data mapping weekly progress review meeting on Monday (07/04) Thanks and Regards /Jasintha *Jasintha Dasanayake * *Software EngineerWSO2 Inc. | http://wso2.com <http://wso2.com/> lean . enterprise . middleware* *mobile :- 0711368118*
_______________________________________________ Architecture mailing list [email protected] https://mail.wso2.org/cgi-bin/mailman/listinfo/architecture
