Skip to Content
1

SessionID Storing in SAP PO 7.4 for Sales Force Integration

Feb 23, 2017 at 01:54 AM

257

avatar image

Hi All,

I have developed SAP PO with Sales Force integration scenario.Here as all you know every time before posting data into sales force we need to get the session ID. i wrote a simple udf for getting dynamic url and sessionID. As a standard the sessionId will expires for every 2 hours.

Now my requirement is to store the sessionID in SAP PO and use the same ID for two hours until it gets expired. This requirement is to reduce the number hits on sales force.Kindly let me know how can we store sessionId dynamially and reuse it.

It will be great if someone can guide me in this regard.

Thanks,

Siva.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Nabendu Sen Feb 23, 2017 at 07:19 PM
0

Hi Siva,

I am not sure if any easy workaround available to store SessionID for 2 hours. You can try with Custom table creation and storing data in Java stack, but that would need lot of customization.

How to persist custom data in SAP PI java table – Part 1

Otherwise if any Database is available in your landscape, you can store and retrieve data with JDBC lookup or for ABAP table RFC lookup. But you have to ensure that after every 2 hours old SessionID should be deleted and you have to run retrieve SessionID function again.

Regards,

Nabendu.

Share
10 |10000 characters needed characters left characters exceeded
sivakrishna sathu Feb 23, 2017 at 09:29 PM
0

Hi Nabendu,

Thank you for responding to my query. But,storing at database level and again deletion has involves a complex scenario.

1. Is it possible to store in value mapping table dynamically and reuse it ?

2. If so, is there any possibility to restrict the UDF not to hit sales force for getting sessionID for each transaction ? (until 2 hours)

Any of your best suggestions will be a great help to me.

Thanks,

Siva.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Siva,

I don't think its possible to store values at run-time within Value Mapping tables. If you anyhow achieve to save SessionID at somewhere, after every 2 hours you have to refresh the value with new SessionID, which would be difficult and I am not sure whether that would be recommended.

Is there any specific reason that you want to avoid this? I don't see any performance / architectural issue behind this design.

Regards,

Nabendu.

0
Rameshkumar Varanganti Feb 24, 2017 at 10:03 PM
0
Share
10 |10000 characters needed characters left characters exceeded
sivakrishna sathu Feb 27, 2017 at 04:46 PM
0

Hi Nabendu,

I'm trying to use RFC lookup for storing and retrieving sessionId. I'm also doing some udf logic changes. I will share the results.

@Ramesh: Unfortunately we don't have any SFDC adapter, so have to work with only SOAP adapter.

Thanks,

Siva.

Share
10 |10000 characters needed characters left characters exceeded