Skip to Content
avatar image
Former Member

JDBC to IDOC Scenario.

HI Experts,

Requirement is i need to fetch the data from multiple tables, but my sender adapter has a query statement where i can select and update the records,

If my client creates a view by fetching the records from differient tables, is there any option to fetch data from the view else sender adapter requires table name to fetch data -- please clarify. ( Simple i can ask like is it possible to fetch data from view provided by them - Does our JDBC sender adapter supports to it)

Is there any other way to pull data from differient tables and convert them to xml or txt file, so that PI can easily pick the files.

Note: The size of the table is too high, so when i use some query statement, how abt the performance

Thanks,

Krishna

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 10, 2013 at 09:29 AM

    Hi,

    >>> is there any option to fetch data from the view

    think about how to make sure that the ones selected will not be selected anymore...

    maybe you can use a stored procedure which will select from many tables and remove them once the SP is executed ? - you can use stored procedures with jdbc adapter in most cases

    >>>Is there any other way to pull data from differient tables and convert them to xml or txt file, so that PI can easily pick the files.

    most DB systems allow creation of XML output from stored procedures - oracle, MSSQL etc. so this is for sure possible however many DBAs don't allow that

    >>>>Note: The size of the table is too high, so when i use some query statement, how abt the performance

    inside the stored procedure you can check how many to send to PI at once (like first 1000 etc...)

    Regards,

    Michal Krawczyk


    Add comment
    10|10000 characters needed characters exceeded

    • With respect to stored procedures think like this if any mandatory field is missing for some records, then entire mapping will fail in this case stored procedure will update those records at the database level, here it is too difficult that to search as many number of records manually to reset the status.

      This is data issue. If the mandatory fields are not showing values after SP result that means you might have to fix the data in the database level.

      >may i know in which cases i can use JDBC lookups.

      THis is basically for the read operation and certainly not for insert/update/delete.  To read a value for a specific column or for a group of few columns in the table. Please search scn for the jdbc lookup.

      Also you might want to see the sap help link about the database transaction level settings for rollback.

      http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

  • avatar image
    Former Member
    Jan 10, 2013 at 09:28 AM
    Add comment
    10|10000 characters needed characters exceeded