Email/JDBC/File adapter- Better performance

[Former Member]

Hi Experts,

We need to develop an outbound interface in PI where the non-SAP system has a database at the backend.

We have the following three options to receive the data from non-SAP system.

1. System will fetch the data from its tables and will create a CSV file and send it to PI by an email( email adapter)

2. System will fetch the data from its tables and will create a CSV file and place it on a local ftp folder from where PI will pick it up ( File adapter)

3.PI will directly connect to the database and fetch the information from the tables (JDBC adapter).

Can anyone please suggest the best option among all? Which adapter will have better performance in this scenario?

This will be a weekly interface and the data volume will be high (<2000 records in one message).

[former_member854360 · Accepted solution]

Hi ,

System will fetch the data from its tables and will create a CSV file and place it on a local ftp folder from where PI will pick it up ( File adapter)

Performance wise and also total development and testing time will be very less in your 2nd option.

[former_member463616]

Hi,

I am also agree with Chirag, use 3rd option, it will feasible solution as per the performance wise also.You can use JDBC adapter.

Regards,

P.Rajesh

[Former Member]

Third option is preferable option as SAP PI can direct connect to database table using JDBC adapter and performance wise also its better as compared to first two.

You need to consider development efforts/FTP environment/maintenance at database system end if u go ahead with first two options and which is not a good design.

[baskar_gopalakrishnan2]

Apparently your third option is the best. PI is a middleware tool to deal with various connectivity standards like web services, JDBC, JMS etc...

We have interfaces using JDBC adapter to deal with more then 50k records every day and PI does great. Handling less than 2000 per week is miniature effort. Go for the third option. Performance wise again dealing directly with database is much better than handling through flat file and further processing in backend.

I recommend third option.

[rajasekhar_reddy14]

The purpose of middleware is to connect SAP/no-SAP system to send/receive data.

you have already PI system in your landscape use PI efeectivelyu like connect to data base system pull data from tables.

2000 records not a big deal at all.

Regards,

Raj