Skip to Content
avatar image
Former Member

RFC to JDBC scenario

Dear Experts,

I have scenario from RFC to JDBC.

How can i build this interface? ,

Once we run a SQL query from PI(Ex: date )  once we sent an date it will trigger through PI to JDBC, Next  given date data should reach to ECC through PI.

And later once we click on post data button in ECC  same data should pass to database through PI.

How can I build this interface, Can you please help me done this.

Is this required to use BPM for this?

Regards

Balu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Sep 14, 2015 at 03:24 PM

    Hi Charan,

    BPM is not needed, even i will advice you to do a Proxy - JDBC scenario.

    First of all you need to deploy the jdbc drivers on PI. (http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/8000cffc-6b92-2d10-3493-f2ac1399242f?overridelayout=t…)

    Later you can do your scenario. If you choose a proxy as a sender you have a good example here http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/e0ac1a33-debf-2c10-45bf-fb19f6e15649?overridelayout=t…

    From ECC perspective, the ABAPers only need to call the proxy, similar than call a RFC.

    Regards.

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 14, 2015 at 03:24 PM

    Hello Charan,

    So your scenario is like

    JDBC->PI-JDBC

    then

    JDBC->PI->ECC

    Then

    ECC->PI->JDBC

    ?

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Charan,

      No doubt Raghuraman option is  the best choice. You should think that your old ccBPM flow control must be done in another place. The easiest way is to do an extra effort on the ECC and to develop this control, that it is really easy for an ABAP developer. Right now, like you are changing your old scenario you can try to use an ABAP proxy, better than RFC, more efficient, easier to manta in and with the possibility of the monitoring.

      There are another alternatives like to do a sync ECC Proxy - ECC Proxy with jdbc lookup on the request and response, but definitely the best way is to develop two scenarios or to use beans as Raghuraman explained.

      Regards.

  • avatar image
    Former Member
    Sep 15, 2015 at 12:13 PM

    HI Experts,

    We are developed RFC to JDBC Sync interface in that When we trigger from ECC it getting error.

    we are getting when we trigger function module in ECC This is the error

    "Short text

        "Wrong Sender Agreement:The Sender agreement does not have channel"

    Some times we are seeing success message. and for this we are not getting any response in PI moni.

    Cheers

    Add comment
    10|10000 characters needed characters exceeded