Creating / Deleting Connections of Excel Clients with Jedox Servers (OLAP / Web)

image_pdfimage_print

In this article we describe Creating, Editing and Deleting Connections, Set a Connection as Default Connection, Connect / Disconnect a Server Connection and Changing the active Jedox Web connection.

With a client/server installation, only the user who is logged in during the installation will be registered with the Jedox In-Memory DB Server. Other users first must register once they connect to the Jedox In-Memory DB Server. The server will remain in the Jedox server list until deleted again.

Creating, Editing and Deleting Connections

To create a new connection or to modify an existing connection, click on “Jedox Wizard” in the Jedox Ribbon.

The Jedox Connection Wizard appears:

Here you will find an overview of existing connections as well as the button “Add connection”.

With right-click on an existing connection you receive the following context menu with three commands:

  • Edit Connection
  • Set as Default Connection
  • Connect / Disconnect

The “Default Connection” is signed with a green checkmark in front of the address.

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

To publish Excel files in Jedox Web or to load Jedox spreadsheets from Jedox Web in Excel, the default connection must have the following entries:

  1. a valid URL connection in the displayed format with a port specification (see screenshot below).
  2. valid user and password entries.
  3. the security token must match the entry “CFG_SECRET” in the file 
    …\Jedox Suite\httpd\app\etc\config.php

 

With the command “Edit Connection” you get the following dialog window. Here you see the entries for the Jedox servers after a default installation:

Here you will find the connection parameters and the buttons “Delete Connection”  and “Test Connection”.

After new entries or changes please click on “Test Connection” to validate them (test needs a correct entry in field “Token”).

With “Save” you accept the inputs, with “Close” you leave the connection wizard without saving any changes.

Connecting Excel Client with Jedox Web Server

In most Jedox installations the OLAP and the Web Server are installed on the same machine. Therefore you must only enter the correct port in the field “Web” to connect to the Jedox Web Server. The http address is the same as for the OLAP connection in this case.
If the two Jedox servers are not installed on the same machine, you have to enter the address of the Jedox Web Server in field “Address” and the address of the Jedox In-Memory DB Server in field “Separate OLAP Address”.

Connecting Excel Client with local Jedox In-Memory DB Server

To create the Jedox OLAP connection “localhost” (supposing that it doesn’t exist), first, select “Add Connection” and then enter the appropriate values in the following dialog box (in the screenshot above you see the values after a default installation).

Connecting Excel Client with a Jedox In-Memory DB Server in the network

Suppose the computer on which the Jedox In-Memory DB Server is installed has the network IP address 10.100.1.245.
To make communication with the Jedox In-Memory DB Server possible for other computers, open the palo.ini file of the server with an editor. Then perform the following modification:

Below the line:

http “127.0.0.1” 7777

Insert the following new line:

http “10.100.1.245” 7778

Save the file and then start the service “JedoxSuiteMolapService” of the Jedox Server again.

Now we can establish a connection with the Jedox Wizard of the Excel client using the following entries:

Of course, the user “john” and his password must exist on the Jedox Server.

Since the original entry – http “127.0.0.1” 7777 – has not been replaced, the server machine still has access through the localhost connection.

For each server entry created with the Jedox Wizard, there will be an entry in the registry.

Connecting Excel Client with a Jedox In-Memory DB Server via a Proxy Server

In this case, enter the following addition in the server field of the connection wizard:

@<Proxyname|Proxyip>:<ProxyPort>

For example: @192.168.2.110:8080

Notes to Jedox Server connections:
  • As of Jedox 7.0, the default connection is also used for the Modeler in Jedox Excel Add-in.
  • On update from a version older than 2018.2, Excel attempts to convert existing connections. If there are an OLAP and a Web connection with the same name (e.g. pointing to a Jedox Cloud), the Jedox Connection Wizard will merge these into a single connection. If there is an OLAP connection that didn’t have a Web connection of the same name, the new connection will simply not set e.g. the token. Therefore, it 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 a Web default connection.
  • In all cases where the user interface is provided by Jedox Web, the Jedox Web language setting for the default connection will be used.
  • Windows Authentication / SSO is still supported

 

Connect / Disconnect a Server Connection

There are several commands to connect/disconnect a server connection:

Changing the active Jedox Web connection

As of version 7.0 SR1, the default connection used by the Excel Add-in dialogs which access Jedox Web can be changed from each dialog directly. To change the connection, right-click the header bar of any Web dialog (for example Modeler), and select the connection from the context menu. The selected connection will then be used in the opened dialog and other dialogs which access Jedox Web.

image_pdfimage_print