QuickBooks Online to Jedox: A Step-by-Step Integration Guide

QuickBooks Online to Jedox: A Step-by-Step Integration Guide

by Jedox 4 BeginnersNo Comments
Hey Jedox friends! πŸ‘‹ If you have ever wanted to bring your QuickBooks Online numbers into Jedox without manually exporting files, this guide is for you. We will go step by step through the setup: first in Intuit Developer, then in Postman, and finally in Jedox Integrator. It may sound a bit technical at first, but once you break it into smaller pieces, it becomes much easier to follow.  Why connect QuickBooks Online with Jedox?  QuickBooks Online is where many companies keep their accounting data. Jedox, on the other hand, is where you can turn that data into planning, reporting, and analysis. A simple example: instead of downloading a Profit and Loss report from QuickBooks every month, you can pull it directly into Jedox and use it in a dashboard, a planning model, or a scheduled report.  What we will build  In the end, we want one thing: a working REST connection from Jedox Integrator to the QuickBooks Online API. To get there, we...
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
Running ETLs via macro using REST standard

Running ETLs via macro using REST standard

by Jedox 4 BeginnersNo Comments
The Integrator Server SOAP API has been deprecated as of Jedox 2022.4. If you used this standard to run ETL via macros you will need to change it now. There are two ways of doing that: Running ETLS via action buttons (highly recommended) Running ETLs via macro using Rest standard Action buttons are now already well incorporated in many Jedox projects and running ETL via them should be an easy task. However if you have issue to build such a connection, check out this link. Running ETLs using Rest standard takes a bit of coding but nothings super complex. IF you had SOAP connection-build-macro-report, make a backup of it and then delete all the code. Have in mind that if you had any IF or any other statements in the code before, make sure to save them. First we need to call the library require library('integrator-rest'); After that code for running looks like this: function sampleETL() {   $etlProject = "PROJECT NAME";   $etlJob = 'JOB NAME';   // define array...
Read More