Jedox OLAP Connection


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

The following parameters must be entered for the connection:

Main Settings


The host name (DNS name) or the IP address of the server on which the database is located.


The TCP/IP port number used by the database.

User Name:

User name for the connection to the database.


Password for the connection to the database.


Name, schema, or instance of the relational database.

Advanced Settings

Use login credentials:

If selected, user will be prompted to login with the credentials entered in the Main Settings.

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