External Data Cube Refresh

Greetings,

Has anyone come up with a way to refresh a data cube externally? Like from a SQL Server Agent job?

Cheers,

Mark

Hi Mark,

You can refresh a cube by doing a REST call to the cube object. By looking at the network trace, Dundas BI does a call like this:

The circled area is the GUID of my data cube.

An easy way to do this might be to create a PowerShell script to emulates the REST calls being made to Dundas BI. The network tab in the chrome debugger should give you everything that you need and can even create PowerShell scripts.

Thanks Jeff! I’ll post if/when I get it working.

Here’s the API docs for that REST call: https://www.dundas.com/support/api-docs/rest/#Dundas%20BI%20REST%20API%20Reference/DataCube/Warehouse/{id}/POST.html%3FTocPath%3DDundas%20BI%20REST%20API%20Reference|DataCube|_____29

Or via python and pydundas: https://pypi.org/project/pydundas/