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

image_pdfimage_print

In this article we describe the following procedures:

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 must register once they connect to the Jedox In-Memory DB Server. The server will remain in the Jedox server list until it is deleted.

Creating, editing, and deleting connections

To create a new connection or to modify an existing connection, click Jedox Wizard in the Jedox Ribbon. The Jedox Connection Wizard appears:

An overview of existing connections is displayed, as well as the Add connection button.

Right-click on an existing connection. The following context menu appears with three commands:

The Active Connection is signed with a green checkmark in front of the address.

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

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

  • A valid URL connection in the displayed format with a port specification (see screenshot below).
  • A valid user and password entries.
  • 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

If the Jedox OLAP connection “localhost” doesn’t exist, you can create it by first selecting “Add Connection” and then entering 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 change the following:

Below

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 on Jedox Server connections:
  • The active 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 an active connection to Jedox Web.
  • In all cases where the user interface is provided by Jedox Web, the Jedox Web language setting of the active 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

The active 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