Jedox OLAP Connection

Access level: read, write

This connection type allows the import or export of dimensions, cubes, and rules from a Jedox OLAP database (In-Memory DB). The host and the port are identified in Settings.

Connection settings

Host The hostname for the connection to the OLAP server. For the local server, the hostname is "jedox-olap".
Port The port for the connection to the OLAP server. For the local server, the port is 80; for the external server, the port is 443.
User name User name for the connection to the server.
Password Password for the connection to the server.
Database Name of the OLAP database.
Use login credentials If enabled, the user will be prompted to log in using the credentials entered above.

It is generally recommended to enable this option, as it ensures that each time this connection is used, it will be in the context of the currently logged in Jedox user, and the user's access rights will be applied.

This option should be disabled in the following scenarios:

  • The connection is used for a job in an Integrator project (as a global connection) that executes something that the normal user running the project (e.g. an end user via an Action button in a report) is not allowed to execute (e.g. creating or deleting a database).
  • The connection points to a separate OLAP instance that uses different passwords or even a completely different user base (in the System database).
Timeout (in s) The timeout for connecting to the OLAP server. The timeout value is in seconds (default: 1200).
SSL mode verify: the certificate is verified.
trust: the certificate is imported to the keystore if not yet available.
off: no SSL used.

Note that a connection to a different cloud instance is only possible if the OLAP version is the same on both sides.

Updated March 27, 2024