Receiver JDBC Syn- Using Views

[Former Member]

Hi Experts,

I have a senario where I need to SELECT data from different Views from Oracle Database( No Stored Procedures). Is this possible to SELECT data from multiple views, if possible how can the MT_response structure looks like.

Please suggest me how can this done.

Regards

Shankar.

[former_member206760]

Shankar,

if actual tables are not allowed to be modified..

try using a single temp table...where all the actual tables will write into...XI can then read from that remp table only

[Former Member]

Tarang Shah,

As I have already mentioned that I dont have any access to create table, I have almost 25 to 40 views need to select. So this is not possible.

Regards

Shankar

[Former Member]

Hello All,

When I do select from different Views( almost 20 ) it behaved similary as table from Oracle DB. So, I have add multiple Statement_response for each View in response structure. So, it worked for me.

**But in PI 7.1 We can import Meta Data of the Table but not a View.

Regards

Shankar

[former_member181955]

Hi

Creat one final view in your Oracle based on required views or tables.Use this final view in PI to get the records.

Thanks

Prasad Nemalikanti

[Former Member]

Hi Prasad,

As Databases are very retricted to modify. As this is migration from other tool to PI. Any new changes on sender or receiver is not allowed.

Any other suggestions !!

Regards

Shankar

[Former Member]

Hi All,

Let I am trying for one VIew first, still I am not getting any response from JDBC receiver. Does JDBC adapter get the response for a View? Is the behaviour of view similar to Table in terms of JDBC adapter. I have not found any kind SAP HELP on this. If any body know this help me.

Regards

Shankar.