Integrations and connections Archives - Page 2 of 2

Charting New Horizons: Navigating Stock and Commodities Markets with Jedox 📈📊

August 25, 2023August 25, 2023 by Jedox 4 BeginnersNo Comments

Hello dear Jedox beginners, In this post, we will take an unusual path and instead of connecting to usual business tools, we will try to extract the commodity and stock data. To do that we will connect to free API at https://www.alphavantage.co/. Alpha Vantage is a financial data provider that offers a wide range of financial market data and services. It provides access to historical and real-time market data for various asset classes, including stocks, cryptocurrencies, forex (foreign exchange), and more. At this moment we will focus on commodity data. The connection will be Rest type and the extract will be from JSON. Technical details for commodities API Resource is: https://www.alphavantage.co/query?function=${Commodity}&interval=daily&apikey=${API} where API Parameters are ❚ Required: function The function of your choice. In this case, function=BRENT which is crude oil. A list of the commodities will come with the model ❚ Optional: interval By default, interval=monthly. Strings daily, weekly, and monthly are accepted. ❚ Optional: datatype By default, datatype=json. Strings json and csv are accepted with the following specifications: json returns the time series in JSON format; csv returns the time series as a CSV (comma-separated value) file. ❚...

Bridging the Gap: Integrating Jedox with ChatGPT for Enhanced Analytics

June 6, 2023June 28, 2023 by Jedox 4 BeginnersNo Comments

In today's data-driven world, businesses rely heavily on advanced analytics solutions to gain valuable insights. One such powerful combination is the integration of Jedox, an enterprise planning and business intelligence platform, with ChatGPT, an AI language model developed by OpenAI. This integration opens up new possibilities for organizations, allowing them to leverage the capabilities of both technologies to achieve enhanced analytics and decision-making. Recently Jedox realised the model which showcases this bond. It can be found on the public marketplace and it is available for everyone. In order to work with the model users will need to have their own API key. Documentation of the model explains in detail how to obtain one and how to set it up in Jedox. The model contains 3 parts: 1st part is where you can send the numeric values to the model and ask it for interpretation of values. The goal is to receive a summary of values and it is good for the people who...

Connect Jedox Cloud and Power BI

April 24, 2023November 20, 2024 by Jedox 4 Beginners4 Comments

To connect Jedox to Power BI, you will need to follow these steps: Make sure that the oData Hub service is running. (check Cloud Console) Obtain the Jedox OData API URL: usually, add odata before the cloud name. Example https://odata.test-jedox4begginers.cloud.jedox.com/DATABASENAME. It is also essential to add a database name at the end. In our case, we will put Biker as a database. Connect to Jedox from Power BI: Here, click on the "Get Data" button in the Home tab, and select "OData Feed" from the list of available data sources. Paste the Jedox OData API URL into the "URL" field, and click "OK" to connect to the Jedox server. Add the username and password. Depending if your team is using SSO choose Windows or Basic for standard Jedox credentials. Import data into Power BI: Once connected to the Jedox server, you can select the Jedox cubes or views you want to import into Power BI. Select the cube or view from the list of available tables,...