Trigger Jedox ETL Jobs via OData – With and Without Variables
Why this topic?
Many Jedox users ask me:
“Can I trigger ETL jobs from outside Jedox? Maybe from Power Automate, or even from a custom app?”
Yes, you can! And the answer is: Jedox OData Hub.
In this post, I will show you how to trigger ETL jobs using OData API – with and without variables. I will also explain how to get the OData license, and give you a real-life use case that maybe sounds familiar to you.
What is Jedox OData Hub?
Jedox OData Hub is a cloud-based service that allows you to access data from Jedox OLAP and Integrator using the OData v4 standard. [knowledgeb....jedox.com]
With it, you can:
Read cubes, dimensions, and views
Run ETL jobs (loads, extracts, transforms)
Pass variables to jobs
Connect to tools like Power BI, Excel, Power Automate, or your own app
🔐 How to get the OData license?
OData Hub is not included by default in all Jedox licenses. You need a separate license which can be found in Jedox Ecosystem Connector License.
To get...