In order to purge cache using direct request create a new
database in repository as follows;
1 )
Set Database to “ODBC Basic”
2 )
Check “Allow Direct Database Request by Default”
Next Step is to add connection pool in the database as
follows;
1)
Set Call Interface to “ODBC 2.0”
2)
Set Data Source Name to “Analytics Web”
3)
Add username and password
In the next step create a direct database request and add
following;
To Purge the whole
cache;
1)
Add Call SAPurgeAllCache(); in the SQL Statement
2)
Provide connection poll information
To Purge cache by
Query;
1)
Add Call SAPurgeAllCache(‘SQL QUERY’); in the
SQL Statement
e.g. Call
SAPurgeCacheByQuery('SELECT Ledgers."Charge #" saw_0 FROM Payments
ORDER BY saw_0');
The query can be obtained from the Manage
Session window in the administration;
2)
Provide connection poll information
To Purge cache by
Table;
1)
Add Call SAPurgeCacheByTable (‘TABLE NAME’); in
the SQL Statement
e.g. Call SAPurgeCacheByTable(
‘CHARGES’);
2)
Provide connection poll information
To Purge cache by
Database;
1)
Add Call SAPurgeCacheByDatabase (‘DATABASE NAME’);
in the SQL Statement
e.g. Call SAPurgeCacheByDatabase(
'SEQUELMED' );
2)
Provide connection poll information
Purge Cache report can also be added as a link on the
dashboard to purge cache at any time;
Furthermore purge cache report can also be added in the
conditional request of an iBot to schedule purging.
Cheers and Long Live Pakistan ;)
Cheers and Long Live Pakistan ;)
