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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  conversion from database to flatfile

    Posted 05/07/13 02:17 PM

    Hi to All,

    Firstly i taken " select adapter service " and then i took “convertToString” , i am giving the path to store the data to file (.txt) to outputfilename but i am not getting the result to the file.

    Thanks in Advance


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 2.  RE: conversion from database to flatfile

    Posted 05/08/13 02:55 AM

    I hope you are providing a folder path of server where webMethods is installed and not your local system path from where you have Developer running.

    Try without providing the file name and check if the string appears in pipeline.

    -Senthil


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods


  • 3.  RE: conversion from database to flatfile

    Posted 05/08/13 01:07 PM

    What is the path you have give on the outputfilename variable in the setValue?

    Also make sure the output string is as expected data:

    HTH,
    RMG


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 4.  RE: conversion from database to flatfile

    Posted 05/09/13 10:45 AM

    Hi Senthil,

    Thanks for giving me reply,
    My Server and web developer running on the same system. I removed the path which i gave in outputFileName as you said but still i am unable to get data in string in the pipeline.

    Regards,
    Reeta


    #webMethods
    #Integration-Server-and-ESB
    #Adapters-and-E-Standards


  • 5.  RE: conversion from database to flatfile

    Posted 05/09/13 10:53 AM

    Hi Rmg,
    Thanks for your reply.I have given the file path in outputfilename variable where I want to save the filedata.

    Regards,
    Reeta


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 6.  RE: conversion from database to flatfile

    Posted 05/09/13 11:24 AM

    If you are not getting the string the pipeline that means some thing is not working right ie parsing to string as per the FFSchema…Do you see any errors in the pipeline?please try to debug more on the schema/file formatting.

    For testing remove the outputfilename and make sure the string outputs as expected first.

    HTH,
    RMG.


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 7.  RE: conversion from database to flatfile

    Posted 05/15/13 10:17 AM

    Hi Rmg,
    Sorry for late reply.I will check the schema/file formatting as you suggested and try to run the service again.

    Thanks and Regards,
    Reeta


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 8.  RE: conversion from database to flatfile

    Posted 05/15/13 10:17 AM

    Hi Rmg,
    Sorry for late reply.I will check the schema/file formatting as you suggested and try to run the service again.

    Thanks and Regards,
    Reeta


    #Adapters-and-E-Standards
    #webMethods
    #Integration-Server-and-ESB


  • 9.  RE: conversion from database to flatfile

    Posted 05/15/13 12:39 PM

    sounds good…test closely see the pipeline:


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards