I have a CSV file. I want to send the data in CSV to database using a DSS service.

How can I use VFS transport for that? Or Do I need to use another mediator for that?

1 Answers

ophychius On Best Solutions

The easiest way would be to have a Data Service that inserts a record into your table.

Then a proxy that deals with the file, the proxy can use VFS to read the file, then a Smooks mediator to transform the CSV to XML.

From there the proxy can iterate over the records from the CSV file and send them to the dataservice.