Connection Wizard in Excel Add-in

image_pdfimage_print

To publish and to store Excel files in Jedox Web or to load Jedox spreadsheets from Jedox Web in Excel, a valid, active connection to the Jedox OLAP server is required. It is also required to use some dialogs and features from Jedox Web, such as Modeler. The connection requires the following items:

  1. A valid URL connection with a port specification
  2. Valid authentication credentials (such as user name/password or Windows Authentication)
  3. The security token must match the entry CFG_SECRET in the file 
    …\Jedox Suite\httpd\app\etc\config.php
  4. The connection must be set as the active connection

Connection parameters for Excel Add-in are established by clicking on Jedox Wizard in the Jedox ribbon, indicated below.

With a client/server installation, only the user who is logged in during the installation will be registered with the Jedox OLAP server. Other users must register once they connect to the server. Connections remain in the list until they are deleted.

Creating, editing, and deleting connections

The Jedox Connection Wizard dialog lists available connections. To edit or delete an existing connection, right-click on it and select an option.

The screenshot below shows the default settings for a local connection, which is created when you install Jedox.

In most Jedox installations, the OLAP and Web servers are installed on the same machine. Since the address will be the same for the OLAP connection, you can leave the Separate OLAP Address field blank.

If the Jedox OLAP and Web servers are not installed on the same machine, you have to enter the address of the Jedox Web Server in the Address field and the OLAP server address in the  Separate OLAP Address field. See Accessing the Jedox In-Memory DB from Client Machines for more information.

If you are accessing the OLAP server via a proxy, you can indicate the proxy server in the Separate OLAP Address field in this manner: <Targetserver_name | TargetserverIP>@<Proxyname|Proxyip>:<ProxyPort>

For example: JEDOX_OLAP | 10.0.0.1@192.168.2.110:8080

Notes on Jedox connections:
  • The active connection is used for several features in Jedox Excel Add-in, including Modeler, Import Wizard, and Data-Driven Modeling.
  • In all cases where the user interface is provided by Jedox Web, the Jedox Web language setting of the active connection will be used.
  • When updating from a Jedox version older than 2018.2, Excel attempts to convert existing connections. If the OLAP and Web connection have the same name (e.g. when they point to a Jedox Cloud), the Jedox Connection Wizard will merge these into a single connection. If the OLAP and Web connections have different names, the new connection will only work for the OLAP dialogs, such as Paste View, but not for the complete functionality of a Web connection, because there cannot be set an active connection to Jedox Web (see next section).

Always test the connection after making changes. 

Setting the active connection

The Active Connection is indicated with a green checkmark in front of the address:

To set a connection as active, right-click on it and select the context-menu option Set as Active Connection.

For Jedox Web connections, you can define multiple connections in parallel, but for complete functionality, one of these connections must be designated as the active connection.

Changing the active Jedox Web connection

The active connection, used by the Excel Add-in dialogs that access Jedox Web, can be changed from each Web dialog directly. To change the connection, right-click in the header bar of any Web-based dialog (such as Modeler), and select the connection from the context menu. The selected connection will then be used in the opened dialog and other dialogs that access Jedox Web.

 

Connecting to or disconnecting from a server

There are different ways of connecting to or disconnecting from a server:

  • Right-click on the connection in the Connection Wizard.
  • In Web dialogs (such as Modeler or Paste View), select the connection from the Connection drop-down list (1) and then choose an option with the cog wheel (2):

4. Setting an authentication method

Authentication options in Jedox include username and password, Windows Authentication (SSO), and SAML. All are natively supported in Jedox. The desired option can be selected from the Authentication drop-down menu in the Edit Connection dialog, as shown below.

image_pdfimage_print