How to into flatfile data (or) record into database

Hi Everyone,

              I am new to webmethods,i am trying to insert data into oracle database using flatfile but i couldn't able to find these services in my developer (version is 7.1)

DBToFF: SelectAdapter

Transformations.FlatFile2DB

and also please guide me how to write flow service to insert data in oracledatabase table from flatfile and viseversa please someone guide me…

Regards,
Eswar

Hi,

Try to go through these step by step scenarios, may be helpful for you.

Flat file to Database

Database to Flat file

Database to Flat

Database to EDI

Thanks

Hi Khan,

Thanks for reply felt happy by seeing one reply to my question.

This might be small issue,but it is big thing to me i am begginer in webmethods…

I did exactly how they done in that link…but .txt file not generating my service and i am confusing in some place.please guide me how to do this flowservice…

1)FF_Practise.services:select_order_details
service out pipeline out
Select_Order_dtailsOutput <–> Select_Order_dtailsOutput

2)converToString
pipeline In service In

Order_details(Order_potest_schemaDT)<-link—>ffvalues
ffschema(FF_Practise.Schema:Order_potest_schema)

3)sample.IO.test:writeToFile

   pipeline In                                            service In

string <-----> filecontent
filename(C:\sample\test\cc.txt)
overwriteflag(Overwrite)

These r the flow steps in my service…

Have you defined the file location where you want to generate file in WmPublic/config/fileaccess.cnf file?
What does that writeToFile service do? You can use pub.file:stringToFile directly.
Post the errors in server.log if you get any.

HTH,
Niteesh

Try to do a debug step by step and let us know where you were stuck up:

  1. Does your select Adapter service run successfully giving you the DB output.
  2. Have your Db values successfully converted to a string variable.

If you have the output of these steps then its not a big deal to get a file as an output.

Share your errors with us.

Thanks,
Vikram

Hi niteesh,

     Thanks for reply,i didn't try StringtoFile and i didn't set file location also.

       Directly i am giving file path somethig like C:\sample\test\cc.txt in my flow service.

Regards,
Eswar

Then server will throw error saying the path has not been defined in allowed path list. Its a must and try that ,let us know if you still face issues.

Regards,
Niteesh

Hi Niteesh,

        In Config folder i couldn't able to see any thing ,that folder is empty.

        WriteToFile will write the string to mentionedpath text file.

and pub.file:stringToFile also not able to find in Wmpublic.pub.file:

What i should i do now please guide me :frowning:

Regards,
Eswar