JDBC to FTP comma delimited format

[Former Member]

I would like to select data from a database with the JDBC adapter and pass it to a flat comma delimited file. Is this possible? If Yes, can you lead me to the correct solution or documentation.

Thanks

Skip Ford

[moorthy]

Hi,

Yes, it is possible.

FOr this you can use Sender JDBC adapter.

In the sender jdbc adapter you can write Select query to fetch the data from the database.

Once you get this into XI, then send the same structure into file system using file adapter. If you need csv file, then use comma separated file.

Just create a flat structure with the field matching to the database table

For more-

http://help.sap.com/saphelp_nw2004s/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

File Receiver Adapter-

http://help.sap.com/saphelp_nw2004s/helpdata/en/d2/bab440c97f3716e10000000a155106/content.htm

Regards,

Moorthy

[Former Member]

Hi,

Of course that it's possible.

Please go through this weblogs and try to find other related to file and jdbc adapter.

jdbc sender adapter:

/people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

file receiver adapter:

/people/arpit.seth/blog/2005/06/02/file-receiver-with-content-conversion

also look in the xi help:

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

regards,

wojtek