Database caching in BW

[Soumitra Bishnu 2]

Hi All,

 

1. Is there any way to implement database caching in BW If yes, how should we develop the process

2. In our project, we are using lot of JDBC Query activities. Is there anyway we can minimize the use of JDBC Query Activities

 

Thanks in advance,

Soumitra

[Manoj Chaurasia]

Hi,

 

 

1. If u are fetching static data then caching is possible, create one process with activities like startup activity, jdbc query and then set variable activity.

 

 

Regards,

Mahendar Reddy K.

[. . 7]

Soumitra,

caching depends upon how much data you need to cache.

if your table is too large then its better to use JDBC queries rather than thrashing the BW engine by keeping it in cache.

In case you need to cache few thousand data from table then better you can use something like static Hashtable (using java activities) and retrieve the same using the key/value pairs.

 

Thanks

Ramesh S

[Lary Smith]

Exactly as Ramesh says. Don't use shared variable for large data sets. Another option is to use caching from BW6 Commons plugin https://macronova.io/bw6-commons. All based on ehcache.

[Suchismita Ray]

Hi, the link provided for the BW6 Commons Plugin does not lead to the download page. Can you please help with the link for the BW6 Commons Plugin for Windows.

[Lary Smith]

just ask MacroNova team to generate a trial for you

 

they are pretty responsive