Sender JDBC adapter

[Former Member]

Hi experts,

I have a JDBC interface to RFC, the RFC receives input from many tables, it is possible with a single sender JDBC retrieve information from different tables?

thanks!

[Former Member]

thank you very much, understood!

[Former Member]

Sorry, the tables have no relationship, i can not do a join ...

Please could you explain, in which a stored procedure?, this is done outside of Xi on the sender, is not it?

[prateek]

Then prefer the third approach. Everything has to be then done at the sender side only.

Regards,

Prateek

[Former Member]

Hi,

Write a Stored Procedure at database level that will fetch the data from different tables and invoke the stored procedure from your sender JDBC channel.

Thanks

Amit

[Former Member]

Hi,

Yes, it is possible. You just need to write a wquery with join statement which will join the tables from where you want to extract the data.

Amit

[prateek]

Either you may use the join statement to select the messages or you may create a stored procedure at the sender side. Another approach could be use of temporary staging table at sender holding all the required data and XI polling that table.

Regards,

Prateek