Is there a way to have or done integration to extract db resultset without exporting the database profile and directly convert to csv format without using a map shape?
Short answer : Yes, you can do it using custom script.
But the real question is - WHY DO YOU WANT TO DO IT?
If you do it that way, you are really missing the capabilities of Integration, Logging etc.
The recommended approach is to use DB profile/operation and map.
We're doing it because the database is keep on adding additional columns and we need to reimport again the database profiles and map it again to csv.
If additional columns are added, what is the advantage if you go with Groovy script?
Anyway, you need to make modification in the code to handle new columns.
Instead of groovy script, I suggest you go with DB Profile/Operation and Map only. This is much more easier compared to groovy approach.
You need to add field in DB and Flatfile profile whenever new columns are added.
Retrieving data ...