I need to build a service wherein i can access the database, get / insert / update values to and from the database and send the response back in Json format. Kindly help me with designing the same.
I am looking for a RESTful service.
You should start from included in Studio examples,
check demo Job with very specific name "demoREST" :-)
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.