Jedox OLAP Connection

This connection type allows the import or export of dimensions, cubes, and rules from a Jedox In-Memory (OLAP) DB.

Settings

Host 127.0.0.1 / localhost
Port: 7777
User name Username for the connection to the database.
Password Password for the connection to the database.
Database Name, schema, or instance of the relational database.
Use login credentials If selected, user will be prompted to log in using the credentials entered above.

It is recommended to NOT use login credentials in the following scenarios:

  1. The connection points to the In-Memory DB that is included with the standard installation and is configured to be used by Jedox Web for the storage of metadata and authentication of Jedox Web users. This is the case for the default localhost connection in standard installations.
  2. The connection points to a separate In-Memory DB that uses the same System database (and thus the same set of users) as the internal one.
Timeout (in s) You can set a new timeout value 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.

Updated June 7, 2024