You can use the connection pool created to clear cache using the nqcmd utility or you can use the analyticsweb data source from the odnc.ini. Below are more details for the nqcmd utility in windows environment.
nqcmd location : D:\oracle\product\user_projects\domains\bi\bitools\bin
syntax : nqcmd -d Datasourcename -u userid -p password -s script.txt -o output.log
example : nqcmd -d AnalyticsWeb -u weblogic-p ****** -s D:\oracle\scripts\purge\purge_cache.txt -o D:\oracle\scripts\purge\logs\Purge.log
Contents of the puge_cache.txt:
Call SAPurgeCacheByDatabase ('database name');
Call SAPurgeCacheAllCache ();
You can add the above to a script and have a process to run the cache purge upon completion of the ETL loads.
Thank you very much for your answers.
Before I received it I have tried by myself.
And the re is one trick about this setup.
nqcmd is available in two locations:
On one of the pages I have found info that file from first location should be used.
But it was returning error:
[DataDirect][ODBC lib] System information file not found. Please check the ODBCINI environment variable.
Connect open failed
After changing path to user_projects, it works
Thank you Christian.
Unfortunately it was not clear for me how exactly I have use it, as in description they are executing nqcmd.exe and from Windows cmd.
What's not clear about it?