Picking data from multiple tables using JDBC

[Former Member]

Hi Experts,

Is it possible to pick the data from multiple Oracle databases at once in an interface using JDBC? If so, How to go about it?

[iaki_vila]

Hi Nishant,

My few cents, there are some problems if you have different ORACLE version because you only can have one ORACLE driver installed in your PI version, i haven't tried the trick suggested by Bhavesh Kantilal in this thread

From multiple schemas i think you can have problems to take the data at once, i think the better approach is to have several scenarios to pick the data and one to merge the data.

Check this note 941317 - XI / PI JDBC Adapter: Known Problems / Incompatibilities as well

Regards.

[Former Member]

Hi Nishat,

Please chek the below thread.

Regards,

[Former Member]

Thanks!