How to Connect Amazon S3 and Jedox via REST Connection

How to Connect Amazon S3 and Jedox via REST Connection

by Jedox 4 BeginnersNo Comments
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