wso2integrationtoolingwso2-integration-studiowso2-esb

wso2 esb poll files, read data, transform data publish record message


My tech req is the following :

  1. Poll CSV Files
  2. Read Data line by line
  3. Transform data to desired format
  4. convert to JSON/XML
  5. Publish data thru REST/JMS
  6. Deploy in WSO2 EI6.1.1

How is this possible in DS Tooling 3.8.0 of WSO2 ?

I know inbound endpoints,mediators,sequences proxy services etc can be used, but cant find a single document/article that helps in doing this.

Where do I start? How do I sequentially execute these steps? Artifacts are independently created, but dont how to automate them to an integration flow.

Appreciate if someone can shed some light.


Solution

  • Solution :

    1. Create empty ESB solution project.
    2. Create Proxy-Service.
    3. Use Smooks-config for tranformation of CSV flat data to XML format
    4. Create endpoint, for producing JMS messages to JMS queue of ActiveMQ.
    5. Use datamapper mediator, if transformation is required
    6. Use log mediator , for logging.
    7. Use property mediator for setting endpoint related properties.
    8. Config - axis2.xml,axis2Client.xml for enabling transport settings on E1611.
    9. Export to CAR file, deploy on EI611 management console.
    10. Happy Testing!!