JDBC TO RFC design help

[Former Member]

Hi

My Scenario as below:

JDBC to RFC.

The requirement is, Data availability on JDBC is not known, but whenever the data is available on database, they will send a file to FTP server saying that Data is available with some number of records.

There is no specific time indiacation, ie data can come anytime.

So here I need to process the file and also see that JDBC channel is open and process the data from Database.

Can somebody help me in configuring this design.

[MichalKrawczyk]

Hi,

there are two options:

1. sender jdbc adapter can pool data from a database

(you can set pooling interval) and once the data is there it will be fetched

with a select statement and you can map it directly to an RFC call

2. you can use a BPM which will wait for the file and once the file is

there it can trigger receiver jdbc call (synchronous) which will return the result

of a select statement which you can again map to RFC

I'd suggest using the first approach

Regards,

Michal Krawczyk

http://mypigenie.com XI/PI FAQ

[Former Member]

Hi Michal,

By any chance can i get screenshot for option #2 ( Thatz how my client required)

It will really grateful.... Pls......

Thanks

VR