Skip to Content
author's profile photo Former Member
Former Member

JDBC TO RFC design help

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Feb 26, 2009 at 09:27 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.