IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
  • 1.  Get dump of database

    Posted Tue August 05, 2014 08:43 PM

    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.


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 2.  RE: Get dump of database

    Posted Wed August 06, 2014 02:48 AM

    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.


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 3.  RE: Get dump of database

    Posted Wed August 06, 2014 10:10 PM

    Thank you, M@he$h!

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


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: Get dump of database

    Posted Thu August 07, 2014 06:15 AM

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

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


    #webMethods-General
    #webMethods
    #Integration-Server-and-ESB


  • 5.  RE: Get dump of database

    Posted Fri August 08, 2014 11:07 AM