Technical Changes for Cloud Users

image_pdfimage_print

This article describes the key user-related objects of a Jedox model that may be affected by the Cloud upgrade. Please check back here regularly as additional items may be added over time.

1. System Logs location has changed

All logs under Administration have now been moved to the Cloud Console. You can review, sort, and filter the logs there. Integrator Monitor execution logs have not changed location and are still available in Jedox Suite.

The specific logs that are now in the Cloud Console include:

  • Jedox In-Memory DB (OLAP/SVS) logs
  • Spreadsheet Server (Core) logs
  • Web Frontend (Apache) logs
  • Web Backend (RPC/Scheduler Server) logs
  • Integrator logs
  • PSF logs
2. Specific commands in macros have changed

Any macro that explicitly refers to “127.0.0.1” will not work in this new environment. Generally, it is inadvisable to hard-code IP or server addresses in macros.

Change all In-Memory DB (OLAP) connections to use system variables. For more information, see Macro Engine API Documentation and refer to the section on the $_JEDOX variable.

Examples of session variables:

When establishing connections to Jedox Integrator in a macro where you are specifying an explicit address, use jedox-etl (instead of e.g. 127.0.0.1) as the address. A port does not have to be specified.

3. Separate address required for Excel connections

When connecting to a Jedox In-Memory DB running in Jedox Cloud, you can set up a connection from Jedox Excel Add-in by copying connection data to clipboard – use “Copy Excel connection details to clipboard” button on Jedox Cloud Console, then switch to Excel, use Jedox Wizard to create new connection – connection data will automatically be populated with the content stored on clipboard:

Jedox Add-in for Excel connection details

Jedox Add-in for Excel connection details

When manually creating or editing a connection in Jedox Excel Add-in, you need to specify the field “Separate OLAP Address” as well as the general address. The ports for both addresses are 80.

In-Memory DB connection

In-Memory DB connection

Address: https://<CUSTOMER DOMAIN>.cloud.jedox.com
Separate OLAP address: http://olap.<CUSTOMER DOMAIN>.cloud.jedox.com
OLAP port: 80
Web port: 80

Note: the connection to Jedox OLAP only uses HTTP for the initialization of the connection. All requests that transfer data use TLS/HTTPS.

4. In-Memory DB connections in Jedox Web Connection Manager

When creating a new connection to your Jedox In-Memory DB (OLAP) server in Jedox Web Connection Manager, the interface to use is jedox-olap, and the port to use is port 80.

5. Changes to SFTP connections to Cloud environment

Hostname for SFTP connection has changed to sftp.<CUSTOMER DOMAIN>.cloud.jedox.com

Sometimes integration processes use a file storage location in Tomcat to store files on the Jedox Cloud file system. The old path for storage was /user_data/live/tomcat-etl/webapps/etlserver/data/files. This path has changed and points now to: /tomcat-etl/webapps/etlserver/data/files

For details, see SFTP Connections to Jedox Cloud in 2020.

6. Settings in Jedox Models

Jedox Models include settings that can be changed in the Administration area of Jedox Web. One of these settings defines the address for Jedox Integrator, specifically the setting system.integrator_server.url. In the new infrastructure, the value of this setting must be changed to http://jedox-etl.

7. Connections to Jedox components in Supervision Server scripts

If your Supervision Server scripts establish direct connections to either Jedox In-Memory DB (OLAP) or Jedox Integrator, the address used when establishing the connection needs to be changed in the script.

Instead of using the network interface 127.0.0.1 (or some other custom interface), use the address jedox-olap and jedox-etl.

The port for OLAP is 80. For Integrator, a port does not have to be specified.

Connections from SVS scripts using the reserved OLAP connections string, such as palo_data("SupervisionServer/$database",...) must not be changed.

image_pdfimage_print