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:
string $_JEDOX['OLAP_HOST'], string $_JEDOX['OLAP_PORT']
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:
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.
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
5. Changes to SFTP connections to Cloud environment
Hostname for SFTP connection has changed to
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
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.