Fetching data from JDBC without using JDBC sender adapter

[Former Member]

Hi all,

My requirement is fetching the data from more than one database table and sending it through XI.

But as per my study using JDBC sender adapter we can only work with one SQL statement, with which I think I can't access more than one table.

I have found one way, that is using Java Proxies. But in this approach, I need to place a java application system into which I need to get data from JDBC tables and then I can start sending data to XI through Java Proxies.

So experts please let me know the possible ways to achieve it.

Thank you.

Regards

Bhanu Tiruveedula.

[Shabarish_Nair · Accepted solution]

My requirement is fetching the data from more than one database table and sending it through XI.
But as per my study using JDBC sender adapter we can only work with one SQL statement, with which I think I can't access more than one table.

you can always write a stored procedure which will fetch data from multiple tables and then send to XI.

use JDBC itself

[Former Member]

Thanks

[chitti_prakash]

Hi Bhanu,

Here you can also use JOINS or UNIONS to access the data from mutliple tables from the DB.

Cheers,

Soorya

[GabrielSagaya]

Hi

You can opt Stored procedure.

But Check prasad's reply