Pooling Specific Abap Table ECC from PI

[Former Member]

Hello PI Experts,

I'd like to know if a PI solution can be develop to pool a distant SAP ECC specific Z* table with a pre-defined frequence (i.e : each hour) ?. This is like a "JMS connector" applied to SAP Table context.

I think about :

-specific connector with RFC call PI->ECC but it seems hard work (adapter framework, Java development, ...?).

-Z* Abap PI schedule, with RFC call on ECC (old school !)

-...

Thanks a lot for yours response.

Regards

Etienne

[Former Member · Accepted solution]

Wild Idea .....

as you are creating Transperent Tables - which should be there in database as it is (as per definition of Transperent Table)

then why not JDBC adapter...

[Former Member · Accepted solution]

Hi NW Expert,

JDBC seems good Idea but ... i'm not expert on JDBC installation.

After quick search : some installation and deployement steps are necessary with admin help (i'm using a Oracle 10 DB on Linux). Have you some links ?.

Thanks a lot

Etienne

[Former Member · Accepted solution]

Hi Beslay,

If you want to go the JDBC route then you need to install the JDBC drivers. Please check this document for installing this:

https://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4d88f&overrid...

Also please check this thread to get the drivers from the oracle site:

Its always best not to access the database table directly. I was you I would write a simple proxy or an rfc which gets the data and then will schedule the proxy as per your requirement.

Regards,

---Satish

[Former Member · Accepted solution]

Satish is saying the exact points (thats why I wrote "Wild Idea")

by the way

JDBC installation is very easy

1) download the JDBC drivers from oracle 10 from oracle site (.jar files)

2) get .sca file from ...../EPC/IN and add this .jar in it, make archieve.

3)run JSPM --- deployment.

it's done. I am not able to find document link currently, try search on SDN.

Edited by: NetWeaver Expert on Aug 6, 2009 1:04 PM

[Former Member · Accepted solution]

Hi,

Thanks. I keep it and find out my administrator for test.

Best regards

Etienne

[Former Member]

Your question is not very clear to me but based on my understanding you can use this blog to schedule your Communication Channel and then use a lookup function in mapping to fetch the data from your Z-table (You have to write RFC for this).

/people/shabarish.vijayakumar/blog/2006/11/26/adapter-scheduling--hail-sp-19-