Connecting Jedox to Databricks: A Beginner’s Guide

Connecting Jedox to Databricks: A Beginner’s Guide

by Jedox 4 BeginnersNo Comments
If you’re working with large datasets and advanced analytics, Databricks is a powerful platform that combines data engineering, machine learning, and analytics in one place. But what if you want to bring that data into Jedox for planning and reporting? In this guide, we’ll walk through the basics of connecting to Databricks via its REST API and pulling data into Jedox. Step 1: Open Databricks and Understand the Structure Start by logging into Databricks. Once inside, you’ll see the Catalog section on the left-hand side. Here’s what the main components mean: Catalog: The top-level container for organizing data assets. Workspace: Your environment where notebooks, jobs, and data live. Database: A logical grouping of tables within a catalog. Table: The actual dataset you query. In our example, the table is orders_2_drillthrough. In the screenshot above, you can see: Catalog: main Workspace: default Database: default Table: orders_2_drillthrough This table contains columns like Year, Month, Products, Customers, and Measures—perfect for analysis in Jedox. Step 2: Generate a Bearer Token To access Databricks programmatically, you need an authentication...
Read More
Trigger Jedox ETL Jobs via OData – With and Without Variables

Trigger Jedox ETL Jobs via OData – With and Without Variables

by Jedox 4 Beginners2 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
Automating User Data Deletion with Jedox ETL – Compliance

Automating User Data Deletion with Jedox ETL – Compliance

by Jedox 4 BeginnersNo Comments
In today's data-driven world, companies operating in Germany and across the EU must comply with strict data privacy regulations, such as the General Data Protection Regulation (GDPR) and other local laws. One key requirement in many industries is the removal of user behavior data after a certain period to protect user privacy. This can include deleting user accounts that have been inactive for a specific duration. The Problem: Removing Inactive Users Automatically Many businesses store user login data, but regulations may require them to delete users who have not logged in within a specific timeframe—for example, 90 days. Manually managing this process is inefficient and error-prone, especially for large organizations. To address this challenge, we can use Jedox ETL (Extract, Transform, Load) to automate the identification and deletion of inactive users. This ensures compliance while reducing manual effort. Solution: Using Jedox ETL to Identify and Delete Inactive Users Jedox ETL allows us to create a streamlined workflow to extract user login data, filter out inactive...
Read More
Create elements in Jedox ETL with Groovy

Create elements in Jedox ETL with Groovy

by Jedox 4 BeginnersNo Comments
In multidimensional databases like Jedox, managing dimensions and hierarchies effectively is crucial for accurate data analysis and reporting. Consolidations, which define parent-child relationships within dimensions, are an important part of this process. In this post, we’ll explore how to automate the creation of base and consolidated elements using Groovy scripting in Jedox ETL. We’ll also dive into a practical business use case to showcase the power of this approach. The Problem: Automating Dimension Hierarchies Managing dimension hierarchies manually can be time-consuming and prone to errors, especially when dealing with dynamic or frequently changing datasets. Using Groovy in Jedox ETL, we can automate the creation and management of elements and their consolidations. This makes the process faster, more reliable, and easier to maintain. Below is a Groovy script that demonstrates how to: Connect to a database and retrieve a dimension. Create base elements and a parent element. Add consolidations between the parent and its child elements. Java documentation here. The Script: Building Base and Consolidations in Jedox Here’s the...
Read More
PGP Decryption for Secure File Handling

PGP Decryption for Secure File Handling

by Jedox 4 BeginnersNo Comments
In today’s post, I’m excited to share an important update coming with Jedox 24.2: PGP decryption is now supported for file uploads, and it works with all major formats—Excel, CSV, JSON, Parquet and XML. This is a big step forward in helping you manage sensitive data securely within Jedox. Why PGP Decryption Matters If you’re handling sensitive or confidential data, security is key. PGP (Pretty Good Privacy) is a widely used encryption method that helps protect files from unauthorized access. With Jedox 24.2, you can now easily decrypt these PGP-encrypted files directly in the platform. This ensures your data stays secure while you work, without needing extra software. Simple and Secure: Using the Jedox Key Vault One of the great things about this new feature is its easy use. You can upload your private PGP keys to the Jedox secure key vault. This keeps your keys safe and ready to use whenever you need to decrypt files. Once your key is uploaded, the decryption...
Read More
Connection to Google Sheets

Connection to Google Sheets

by Jedox 4 BeginnersNo Comments
In today's data-driven world, integration between different platforms is essential for efficient workflow management and data analysis. With the latest integration of Google Sheets within Jedox with version 24.1, users can now combine the power of Jedox's data management and analytics capabilities with the collaborative features of Google Sheets. In this beginner's guide, we'll walk you through the steps to set up this integration and harness its full potential. Setting Up Google Cloud Project The first step in integrating Google Sheets with Jedox is to create a Google Account if you don't have one already. Then, head over to Google Cloud Console (https://console.cloud.google.com/) and create a new project. Creating OAuth 2.0 Client ID Once the project is created navigate to the Credentials section in your Google Cloud Console https://console.cloud.google.com/apis/credentials and create an OAuth 2.0 Client ID and Secret. Make sure to specify the authorized UI as https://developers.google.com/oauthplayground to generate Refresh and Access Tokens. Generating Tokens with OAuth 2.0 Playground Utilize the Google OAuth 2.0 Playground to...
Read More
Mastering File Compression and Extraction in Jedox

Mastering File Compression and Extraction in Jedox

by Jedox 4 Beginners3 Comments
Welcome, Jedox enthusiasts! In today's tutorial, we'll dive into file compression and extraction using Jedox, specifically, the powerful FILE.unzip function. As a prerequisite, we will need to create some folders in our backend which will be used for testing purposes. Connect to your backend with some tool like WinSCP. If you don't have your credentials check the cloud console. If you do not have access to the cloud console - contact cloud support. Once you are connected create 2 folders in /etl_data/files/etl_data/files/For Zipping/etl_data/files/For Unzipping In "For Zipping" folder add Excel files 1,2,3. In the "For Unzipping" folder add two zipped files "ZippedWithoutPass" and "ZippedWithPass". The password for unzipping is in the file pass. (Download the whole project at the bottom of the page) At the same time we need to create some directory and file locations in Jedox which will be used as a path for the following scenarios: Scenario 1: Compressing a File into a Zip Folder The first scenario we'll explore is the basic compression of a...
Read More
Report Management in Jedox: Converting report paths to dimension elements

Report Management in Jedox: Converting report paths to dimension elements

by Jedox 4 Beginners7 Comments
Are you looking for an efficient way to manage and organize your reports in Jedox? This guide will explore how to export folders and files from Jedox Report Designer and transform them into a dynamic dimension of elements within the Modeler. By leveraging the paths as attributes, we can create an easily navigable system to represent all reports in the Jedox environment, enhancing user experience and productivity. Export the project from here. Exporting Folders and Files from Jedox Report Designer Organize Your Reports: Ensure your reports are systematically organized within the Jedox Report Designer for exporting. Export Data to Modeler: Utilize the ETL Integrator to transfer folders and file names as dimension elements to the Modeler. Check the project for the details. Creating a Dimension with File Paths as Attributes Set Up the Dimension: In the Modeler, create a new dimension with the exported file paths as attributes, allowing for a representation of the report structure. Configure Attribute Settings: Customize the attribute settings to ensure navigation and...
Read More
IOUtils.setByteArrayMaxOverride() issue

IOUtils.setByteArrayMaxOverride() issue

by Jedox 4 BeginnersNo Comments
Upgrading to the 2022.2 version brings more perks and features. One of these is also the IOUtils.setByteArrayMaxOverride() issue. Usually, it comes in this type of form and states that the maximum length for this record type is achieved. The fix is very simple. If you have access to the config file it is necessary to add this line: Afterward, you just need to restart the ETL service and you are ready to go. In case you don't have access, please write to Jedox Cloud Support....
Read More