Blog

On this page you will find Tutorials, How-Tos and Tips for developing with open bi.

Connecting to another open bi instance

This blog post shall give you all necessary information on how to connect open bi to another open bi instance. This makes sense e.g. in the following scenarions:

  • Setting up a system landscape with development and production systems
  • Setting up distributed system landscapes with load balancing, where multiple open bi instances provide the same services and therefore have to share the same data.
  • Publish data and reports of a private instance of open bi onto a publicly available portal, e.g. for your suppliers.

Creating the Connection

You can create the connection easily via the open bi Web Configurator. First, specify the open bi instance you want to connect to as Hostname, and also enter username and password:

After successful logon, navigate to Connection Templates and choose OPENBIP:

After double clicking on OPENBIP, you see the already existing connections. Click + to create a new one:

First, you should provide a Name and Description for the new connection:

Then you should specify the HOSTNAME and PORT for the new connection:

Make sure to add USERNAME and PASSWORD with isSupplied set to false. This will make sure the users are automatically queried for username and password when they connect to the system.
Alternatively, you can enable single-sign-on by using the placeholders "%OPENBI_USERNAME%" and "%OPENBI_PASSWORD%" and isSupplied set to true.

For details, see the detailed parameter documentation below.

Connection Parameters

If you are using https, make sure that both surce and target open bi instances have valid certificates installed and can receive https requests.
Parameter Name
Documentation
Parameter Name
HOSTNAME
Documentation
The hostname of the open bi instance, to which all connections shall be opened.
Parameter Name
USE_HTTPS
Documentation
Defaults to "false" and a http connection. Set to "true" to enable https connection.
Parameter Name
PORT
Documentation
The http(s) port that is used for the connection.
Parameter Name
USERNAME
Documentation
The username to be used for log in.
Parameter Name
PASSWORD
Documentation
The password to be used for log in.
Thilo Knötzele
Author: Thilo Knötzele
Creation date: 14.07.2021
Category: Connections
back to overview