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 it:

1. Contact your Jedox Sales Representative

Once you have the license, your OData endpoint will look like this:

https://odata.{yourInstance}.cloud.jedox.com/

---

💡 Use Case: Triggering ETL from Power Automate

Let’s say you are working in a company where sales data is uploaded daily into Jedox. But the upload should only happen after a manager approves it in Microsoft Teams.

You can build a Power Automate flow like this:

1. Manager clicks “Approve” in Teams
2. Power Automate sends a request to Jedox OData Hub
3. Jedox runs the ETL job that loads the sales data

This is possible because OData Hub supports job execution via HTTP.

---

Triggering a Job Without Variables

To run a job without variables, you can use a simple HTTP POST request like this:

POST https://odata.{yourInstance}.cloud.jedox.com/Integrator('globalprojects')/Projects('SalesETL')/Jobs('LoadSales')/Run
Authorization: Basic {username}:{password}

This will start the job LoadSales inside the project SalesETL.

---

Triggering a Job With Variables

Let’s say your job needs a variable like Year=2025. You can pass it like this:

POST https://odata.{yourInstance}.cloud.jedox.com/Integrator('globalprojects')/Projects('SalesETL')/Jobs('LoadSales')/Run(Variables='Year=2025')

You can also pass multiple variables:

Run(Variables='Year=2025;Region=EMEA')

Make sure your variables are defined in the Integrator project. You can define them under the Variables section in the project tree. [knowledgeb….jedox.com].

If you copy the link after POST in your browser, it will also be executed, meaning you can include this link in any actionable button in your applications, and the jobs will be triggered.

---

Bonus Tip: Monitor Job Status

After triggering a job, you get a response like this:

{
  "id": 5913,
  "status": "Queued"
}

You can then check the status using the job ID:

GET https://odata.{yourInstance}.cloud.jedox.com/Integrator('globalprojects')/Jobs(5913)

This will return the current status: Completed successfully, Failed, etc. [github.com]

---

Testing it Yourself

If you want to test this:

• Use Postman or Power Automate

• Use Basic Auth (username/password)
• Make sure your Jedox version is 21.3 or higher
• Use a cloud instance (OData is not available on-prem)

---

What else can you do with OData?

Besides triggering jobs, you can:

• Read cube data into Power BI or Excel – https://jedox4beginners.com/connect-jedox-cloud-and-powerbi/
• Build dashboards with live Jedox data – https://jedox4beginners.com/connect-jedox-cloud-and-powerbi/
• Automate workflows with Power Platform
• Embed Jedox reports into other apps – https://jedox4beginners.com/embed-power-bi-reports-in-the-jedox/

---

Final Thoughts

OData is a powerful tool, but many users don’t know it exists or how to use it. I hope this post helps you understand how to trigger ETL jobs and pass variables in a simple way.

If you’d like to see a full working example with Power Automate or Postman, please let me know in the comments – I can prepare a follow-up post.

If you think this helped you in your projects and saved you some time don’t hesitate to support our blog at https://buymeacoffee.com/stefanvelickovic33. It helps us to run and host the website.