Get dump of database

[Igor_Morozov]

Hello!
I am newby at webMethods and my main programming language is C#, so I didn’t really work with eclipse.
I faced with the problem to get the dump of database. I’ve created JDBC adapter with connection to my database and I can perform operations on the database like Select, Update, … But I don’t understand how to get my table data to .csv file. If I perform Select without any conditions I can save results in XML. But I don’t need it in XML, I want all this data in .csv file. Is it possible? Please help me with this problem.

[Mahesh_K_Sreenivas]

If you want to extract the table contents into a .csv file, you must use flat file handling in webMethods. For more information refer the flat file developers guide from SAG documentation.

And also lets see what others have to say about this.

[Igor_Morozov]

Thank you, M@he$h!

@M@he$h

For more information refer the flat file developers guide from SAG documentation.

Could you please provide me the link to this guide? I didn’t find this one.

[Mahesh_K_Sreenivas]

@Igor Morozov

Thank you, M@he$h!

@M@he$h

For more information refer the flat file developers guide from SAG documentation.

Could you please provide me the link to this guide? I didn’t find this one.

You can download the guide from the below link, I hope you have the access

http://techcommunity.softwareag.com/ecosystem/documentation/webmethods/wmsuites/wmsuite8-2_sp2/Integration_Server/8-2-SP1_Flat_File_Schema_Developers_Guide.pdf

[Igor_Morozov]

Yes, I have the access. Thank you!