File Adapter

[Former Member]

what are the drawbacks of File Adapter

Thanks

[santhosh_kumarv · Accepted solution]

1. It can connect only thru NFS or FTP and not SFTP.

2. Can process only text/csv files.

3. Using Content conversion can only convert flat structure to a simple xml structure and not a a deeply nested structure.

Thanks

SaNv..

[Former Member · Accepted solution]

>>. Can process only text/csv files.

Not true,can pick up any file.

>>Using Content conversion can only convert flat structure to a simple xml structure and not a a deeply nested structure.

Again not true,you can have as many hierarchies as possible,just design the data type correctly and use proper mapping technique(preferably java or XSLT for complex message hierarchy)

Thanx

Aamir

[Former Member]

Hi,

I am adding one more point

There is no security for the data in the file adapter

[former_member193376]

Hi

Disadvantage:

1) Does not produce XML directly like JDBC adapter.

2) Content conversion is difficult and need lot of effort to produce the desired structure

3)It cannot produce the output in the form a hierarchy

4)Also File adapter doesnt produce the response neither it supports the acknowledgement.

5) You cannot send an attachment using file adapter

Thanks

Saiyog

Edited by: Saiyog Gonsalves on Jul 29, 2008 5:04 PM

[santhosh_kumarv]

Hi,

With the standard functionality you cant achieve.

You have to go with adapter modules for processng the other format files.

Check this Blog for processing an excel file using Adapter module..

By Prasad Ulagappan

By Prasad Ulagappan

By Ravikumar Allampalam

Thanks

SaNv...