Trigger Jedox ETL Jobs via OData – With and Without Variables

Trigger Jedox ETL Jobs via OData – With and Without Variables

by Jedox 4 Beginners4 Comments
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...
Read More

Integrating DeepL with Jedox: Smarter Translations for Global Planning

by Jedox 4 BeginnersNo Comments
Introduction Jedox is a powerful platform for enterprise planning, but when teams span multiple languages, communication can become a challenge. That’s where DeepL, an AI-powered translation service, comes in. In this post, we’ll explore why integrating DeepL with Jedox makes sense, how to do it, and where it can add real value—especially in translating comments and user-generated content. Why DeepL? Accurate translations: DeepL is widely praised for its natural-sounding translations, especially in business contexts. Fast and scalable: Translate content instantly without leaving Jedox. Improved collaboration: Make dashboards and reports accessible to global teams. How to Integrate DeepL with Jedox Step 1: Get Your API Key Visit https://developers.deepl.com/docs/getting-started/intro and sign up for an API account. You’ll receive an auth_key to use in your requests. Step 2: Create a REST Connection in Jedox Integrator Go to Integrations > Connections Choose REST as the connection type Set the base URL:https://api.deepl.com/v2/translate Add parameters: Authorization=DeepL-Auth-Key [YOUR_API_KEY] Content-Type: application/json Accept: application/json text=YourText target_lang=EN (or any supported language code) Use Cases in Jedox 1. Translating Cell Comments Enable users to write comments in their native language and have them auto-translated for reviewers in other regions. 2. Multilingual Dashboards Use DeepL to translate...
Read More