Database Table Access

[manigram]

Hi All,

We have a option to explore the database table in SQL Query browser option in SAP PO 7.31.

I want fetch the table for particular interface , is it possible and how to fetch the specific interface table.

Regards,

Mani

[baskar_gopalakrishnan2]

You can use either JDBC sender adapter or receiver.  Since you do query, this can be achieved in both. Depending on the requirement you choose either sender or receiver.  If your sender system is jdbc then use jdbc sender option otherwise receiver.  Please refer these links. If you have more questions, let us know.

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

http://www.riyaz.net/sap/jdbc-adapter-configuration/1200/

http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

[Former Member]

HI,

YOu can fetch the structure of the table from the data base directly

1. Create a receiver database communication channel and specify necessary driver information in the JDBC receiver comm channel.

2. In ESR: go to external definiton and choose an option of table and then choose comm channel which is created in ID, so it displays all tables which is present in data base and you can import structure directly and can be used in mapping.

Thanks,

--Sai

[manigram]

Hi all,

Thanks for all to reply over here, already we have a option to explore the database table in NWA. Is ther any way to fetch the particular interface related table.

I want to fetch one particular field values in one interface for specific time period.

Regards,

Manigandan

[Dimitri]

Dear Mani,

Try to post your question in the PI & SOA Middleware community.

I guess you get a quicker response over there.

Kind regards,

Dimitri

[Former Member]

discussion moved into the PI & SOA Middleware space.

[Dimitri]

Thank you, Mariana.

And I already see response. Nice!