Sharepoint 2010 BCS - how to set cache expiration date?

Question

I want to receive data from SAP "only once a day" and store it in the BCS Sharepoint 2010 cache. How / Where can I make this parameter that allows BCS to know that it should only query the SAP data source once a day?

Any help is really appreciated.

Answer 1

You should be able to interact with SAP through the ISubscription interface. From there, you can set the expiration time for specific queries and associations. So, for an ISubscriptionQuery query you can set a one-day expiration like this:

 query.ExpireAfter = TimeSpan.FromDays(1); 

For more information on setting these properties, see the MSDN article:

http://msdn.microsoft.com/en-us/library/ff464396.aspx#Y342

Answer 2

Does the server need to receive SAP data once a day and cache it? If so, the BCS cache will not help, because the server only caches the BCS model. BCS data is cached on the client side. The ISubscription interface will work for the client, but this means that SAP data will be requested once for each user.

Answer 3

Please view these MSDN messages -

The cache is available only on the client, not on the server. .

caching BCS data in Search Server 2010

Hope this helps :)