JDBC connection

[former_member229310]

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.

[former_member229310]

thanks

[Former Member]

Hi, I have the exactly same issue in my scenario.

MS SQL 2005 has to trigger JDBC in SAP PI/XI.

How did you solve it?

Thanks.

[baskar_gopalakrishnan2]

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.

[martin_dejl2]

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.

[maciej_jarecki]

Hi

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

Regards

Maciej

[former_member181962]

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