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