Skip to Content
avatar image
Former Member

jdbc sender

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 26, 2017 at 06:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded