Integrations and connections Archives

How to Use Drillthrough in Jedox with PostgreSQL

December 17, 2024December 18, 2024 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,...

PGP Decryption for Secure File Handling

October 3, 2024October 6, 2024 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...

Attaching items and sending email via Groovy in Integrator

August 30, 2024August 30, 2024 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...

Connection to OneDrive

May 6, 2024May 24, 2024 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...

How to Connect Amazon S3 and Jedox via REST Connection

April 4, 2024April 4, 2024 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...

Connection to Google Sheets

March 16, 2024March 16, 2024 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...

Integrating Jedox Reports from Excel to PowerPoint

January 26, 2024January 26, 2024 by Jedox 4 BeginnersNo Comments

In this guide, we’ll walk you through the steps to integrate Jedox reports from Excel into PowerPoint presentations, allowing for dynamic and effortless updates. Step 1: Creating a Paste View with the Jedox Add-in for Excel Rescently, Jedox released a new Excel 365 Add-in which allows you to read and analyze data from your Jedox instance and store values and comments to the Jedox In-Memory Database while using Excel 365 desktop or browser, without requiring local installation, simplifying deployment and access to the latest features. So to begin, open Excel and ensure you have the Jedox Add-in installed. If you haven’t already installed it, you can find detailed instructions on how to do so here. Once the add-in is installed, navigate to the data you want to include in your PowerPoint presentation. With the Jedox Add-in, you can easily create a Paste View by selecting the desired area of your spreadsheet. This Paste View serves as a snapshot of your data that can...

Embed Power BI reports in the Jedox

January 20, 2024January 23, 2024 by Jedox 4 BeginnersNo Comments

Last time we learned how to connect Jedox with Power BI via oData and how to utilize the Jedox planning capability in the Power BI Dashboard. https://jedox4beginners.com/connect-jedox-cloud-and-powerbi/ Today, we go another direction and present the case where we will show how to embed Power BI reports inside the Jedox. In the realm of business intelligence, using the power of multiple tools can lead to unparalleled insights. In this guide, we'll explore the integration of Power BI reports into Jedox, unlocking a synergy that amplifies your analytical capabilities. Follow these straightforward steps to embed a Power BI report into your Jedox environment: Step 1: Create a Power BI Dashboard Begin by logging into your Power BI account and crafting a comprehensive dashboard that encapsulates the data you wish to analyze. Ensure that the visuals and insights align with your business objectives, offering a clear representation of the information you aim to convey. Step 2: Embed the Power BI Report Once your Power BI dashboard is polished, navigate...

Loading GPS Coordinates – Jedox XML Connection

January 4, 2024January 4, 2024 by Jedox 4 BeginnersNo Comments

Happy New Year, fellow Jedox enthusiasts! In today's article, we'll be delving into an interesting use case: extracting GPS coordinates in XML format from the OpenStreetMap Nominatim API (https://nominatim.openstreetmap.org/). This adventure will involve using a constant table as a source for countries and cities, interacting with the Nominatim API to retrieve latitude and longitude data, and finally looping and storing this valuable information in the Jedox database. This type of use case is often visible when our cube contains a Geography dimension and then we would like to enhance attribute collection by additional parameters like latitude and longitude. These are very useful in case you would like to create a widget map. Something similar can be found: https://jedox4beginners.com/geocharts-visualisation-in-jedox/ Let us follow the next 4 Steps. Step 1: The Constant Table: In Jedox, we'll create a constant table containing a list of countries and cities. This table will serve as our foundation for the XML extraction process. Think of it as a map guiding us...

Connection to Snowflake ❄️🔄📊

September 6, 2023September 7, 2023 by Jedox 4 BeginnersNo Comments

The upcoming release of Jedox in 2023.3 is set to bring exciting advancements to the ETL (Extract, Transform, Load) process by introducing a seamless connection to Snowflake, one of the leading cloud data warehousing solutions. With this integration, users can enjoy efficient data handling with two authentication options, enhanced by considerations for roles, warehouses, and databases. After choosing the connection there are certain credentials which need to be added. Authentication Options: Username and Password: This traditional method allows users to authenticate their access to Snowflake by providing their username and password. This secure authentication process ensures that only authorized individuals can access and manipulate data within Snowflake. Private Key Configuration: For those seeking enhanced security, the new connection also supports private key authentication. Users can configure their Snowflake accounts to accept private key authentication, adding an extra layer of protection to their data. The Jedox-Snowflake integration doesn't stop at authentication methods. It also provides valuable features to help manage roles, warehouses, and databases seamlessly: Role: Users...