jdbc sender

[former_member327037]

1.Please clarify on database possibilities maintained by third party customer or landscapes maintained by database

2.when to go for stored procedure?

3.when to go for staging table?

4.what are the possible ways to approach?

[iaki_vila · Accepted solution]

Hi Sai,

1.Please clarify on database possibilities maintained by third party customer or landscapes maintained by database

You have to take the jdbc drivers for the DB vendor. I don't know what you are asking here concretely.

2.when to go for stored procedure?

I used stored procedure when i need to take the data from several tables, although you can use a join. Also when you can not do the update equal that the Selec, i had problem with this with Oracle DB. Also if you want to poll the DB with higger frequency and this DB can be receiving data frequently, to avoid inconsistencies between the Select and the Update.

3.when to go for staging table?

For easier scenarios, when you have a flag in the table to know what registers has been taken, the opposite reasons that the SP.

4.what are the possible ways to approach?

Sometimes if you have a SAP ECC system involved, i make a job in ECC and go to the DB as receiver, therefore i take the registers available and in a second scenario i update the registers taken.

Regards