Best way to move data from table to a file

[Former Member]

Hi,

I have a two tables in ecc, And I need to read the data and copy to a file and ftp to another server.

One table is really huge. What is the best approch to move this data using PI. I can not avoid PI, since it needs some mapping.

1. Proxy-PI-FTP

2. Dump the data to a file and use FTP_PI_FTP

3. Any other.

Thank you

Moni

[Former Member · Accepted solution]

it is really a project decision but I can give you some pro's and con's.

Proxy --> File

You cab communicate directly with the XI pipeline which means you don't have to go through the adapter engine.

RFC --> File

This is very standard SAP and most ABAP programmers will be able to utilize this.

IDoc --> File

Standard SAP ALE technology but can get very big due to useless segments

Dump File

The biggest positive of this is the fact that you wouldn't have to convert to XML which will ensure that the message doesn't grow in size as is the case with all of the above.

This is very brief but should give you a good idea....

[Former Member]

Hi,

According to my knowledge proxy is better(performance wise also it is better).

Check this links