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
Connection to Google BigQuery

Connection to Google BigQuery

by Jedox 4 BeginnersNo Comments
If you're working with data in Jedox and need to pull information from Google's BigQuery, you're in the right place! In this guide, we'll walk you through how to set up the REST connector in Jedox, authenticate using Google tokens, and pull data from BigQuery. Why Big Query Uses a Modified JSON Format Before we dive into the steps, it's good to know why BigQuery uses a slightly different version of JSON. BigQuery expects newline-delimited JSON (NDJSON), where each JSON object is on a separate line. This makes it easier to process large datasets efficiently. If you're preparing data for loading , make sure it's in this format. For example: {"id": 1, "name": "Alice"} {"id": 2, "name": "Bob"} This is why we can't just use standard JSON where everything is wrapped in one big array. Step 1: Get Your Google Token for Authentication To connect Jedox to BigQuery, you need to authenticate using a Google token. Here's how to get it: Go to the Google Cloud Console https://console.cloud.google.com/. Navigate...
Read More
How to Use Drillthrough in Jedox with PostgreSQL

How to Use Drillthrough in Jedox with PostgreSQL

by Jedox 4 BeginnersNo Comments
Drillthrough is a very useful feature in Jedox that helps users get more detailed data directly from their cubes. For example, when analyzing aggregated data, you can right-click on a cell in your report and see the detailed information behind it. This can save a lot of time when you need deeper insights without creating complex new reports. In this article, I will explain: Why drillthroughs are used. What options do you have for setting up drillthrough. A step-by-step guide on how to use PostgreSQL as a drillthrough source in Jedox. A referral link to get started with a free PostgreSQL database on Aiven. Why Use Drillthrough? Drillthrough is commonly used in analytics to: Quickly check the source data behind aggregated values. Validate the data loaded into the cube. Provide more transparency to report users who want to see raw data. For example, if you have sales data aggregated by country, a drillthrough could show the transactions from individual stores or sales representatives in that country. Options for Drillthrough in Jedox In Jedox,...
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
Attaching items and sending email via Groovy in Integrator

Attaching items and sending email via Groovy in Integrator

by Jedox 4 BeginnersNo Comments
Hello, dear readers! Today, I want to share with you an important use case that might be very useful in your daily work with Jedox. If you are working with Jedox Integrator and Report Designer, sometimes you need to automate processes to make your work easier and faster. One of these tasks might be copying a file from Report Designer, saving it to your file system, and then sending it as an email attachment. I will show you how to do this using a Groovy script. Let’s imagine a scenario where this might be necessary. Business Scenario Let’s say you are working in the finance department of a company, and every month you prepare financial reports using Jedox. These reports could be in different formats, like Excel (XLSX), CSV, or even images like PNG. After preparing these reports, you need to send them to your colleagues or your boss for review. For example, you generate a monthly sales report in Excel format using...
Read More
Connection to OneDrive

Connection to OneDrive

by Jedox 4 Beginners1 Comment
This week we will talk about how can Jedox connect to OneDrive. OneDrive is a cloud storage service developed by Microsoft, allowing users to store files and photos securely online, accessible from any device with an internet connection. It integrates with Microsoft Office applications and offers collaboration features for sharing and editing documents in real time. We will showcase two ways of doing it, with a username and password and with a token connection. Connecting with Username and Password This method is less secure but allows users to simply access the files. Upload the file you would like to access from Jedox and specify the path: It is important to know your Azure application ID. you can request it from your IT department or in case you have access to your application Azure find it here: Now, if you test your connection to file it should be successful. Connecting via Token Connection As for the first case, you will need to have existing credentials to access the...
Read More
How to Connect Amazon S3 and Jedox via REST Connection

How to Connect Amazon S3 and Jedox via REST Connection

by Jedox 4 Beginners1 Comment
In today's data-driven world, integrating various systems and services is essential for efficient data management and analysis. Connecting Amazon S3, a powerful cloud storage service, with Jedox, a leading enterprise planning and analytics platform, can streamline data workflows and enhance decision-making processes. In this tutorial, we'll guide you through the process of setting up a REST connection between Amazon S3 and Jedox. Prerequisites Before we begin, make sure you have the following prerequisites: Amazon Account Creation: If you haven't already, sign up for an Amazon Web Services (AWS) account here. Creating an S3 Bucket: Log in to the AWS Management Console and create a bucket in Amazon S3 to store your data. Generating a Policy: Generate a policy in AWS Identity and Access Management (IAM) to define permissions for accessing the S3 bucket. Uploading a File to the Bucket: Upload a file to the S3 bucket to test the connection. Creating a Role: Create an IAM role to grant access to AWS resources. Creating a REST API: Set...
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