Skip to Content

JDBC connection

Hi,

My scenario is

JDBC <---> Abap Proxy. Synchronous

JDBC connection to be run at 10am daily. So this can be achieved by configurin avaiability time.

Issue: Also user would make adhoc changes during the day time to correct the errored entries in database and he wants some triggering event at JDBC to trigger PI to pick the data ONLY WHEN HE WANTS TO PUSH DATA after correcting. User dont want to schedule a hourly job to monitor the JDBC. He wants some manual triger to PI from the database (mySQL). How can they triger any event from DB to PI.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Posted on Apr 19, 2011 at 07:48 PM

    Its more of a setting that is to be done on your Database side.

    Not much can be done from PI side.

    Try posting in some mySQL forum.

    Best Regards,

    Ravi

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 19, 2011 at 08:46 PM

    Hi

    MS SQL has posibillity to triger Webservice. So perhaps you should change your interface to SOAP <-> Abap proxy.

    Regards

    Maciej

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 19, 2011 at 08:46 PM

    Hi,

    do "they" use really only DB? You wrote "How can they triger any event from DB to PI." I believe that they have some application which is using mySQL. I assume it's some WebApp probably based on PHP or something similar. So if i'm right, data are updated from that application and not directly in DB. This means, that somebody has to implement additional logic in that application to trigger PI.

    - You can prepare WebService with using SOAP adapter on PI and they will implement it.

    - Or you can create sender JDBC channel which would normally polling that DB, switch it to ExternalControl and give them URL to enable and URL to disable the channel. It means that they will have to start the channel, wait some time and then again stop the channel. Check [this|http://help.sap.com/saphelp_nw04/helpdata/en/45/0c86aab4d14dece10000000a11466f/frameset.htm] for more info about external control.

    Second option is easier in this case. Question is, if more users can work on same DB data at the same time and therefore trigger PI at the same time. This may lead to data inconsistency.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 19, 2011 at 08:57 PM

    One more possible way to do...

    Create SOAP to Proxy Synchronous scenario. During mapping do JDBC lookup and map the db record to proxy. You can let user or DB side to trigger PI via SOAP sender adapter. Once SOAP Adapter got trigger, do the JDBC graphical lookup and retrieve resultset and map to target (proxy) and return the proxy response to sender(soap) (if required).

    Question: How many records are U going to select in jdbc?

    Hope that helps.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 05, 2011 at 11:27 PM

    thanks

    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.