Connections

Connections to SAP systems, Theobald XU.iQ or Power BI can be maintained under Connections.

Maintaining Connections

Create

New connections can be added by clicking the Add Connection button in the Function Panel and then selecting the type of connection you want to add.

Edit

Existing connections can edited by pressing the Edit button in the Actions column.

Delete

Existing connections can be deleted by pressing the Delete button in the Actions column. This will also remove all related SAP Entities.

SAP Business Warehouse Connections

The following parameters need to be filled in:

The SID of your SAP BW system
The domain of your Server
Instance number
Client number

Optional parameters are:

Function Module Prefix of the function module RFC_GET_STRING

Since version 2023.2 of Enterprise Glossary, the Function Module is optional for certain versions of SAP BASIS, see here: Function module RFC_GET_STRING

HTTPS-Port is needed for the download of SAP BW Queries
SAP Router String
Logon Group and
is needed to get the data from SAP. Per default it is set to ¦. If you use that character in description in SAP, please change it.

Other than that, the connection has to have a Name, and to make the connection User name and Password have to be maintained.

At the end of the page the Connection Mapping can be maintained. For every added S/4HANA System the Logical System in the BW System can be maintained. That is needed to see the full Data Origin and the full Data Lineage.

SAP Business Objects Connections

The following parameters need to be filled in:

Name
RESTful URL
Login with User and Password

SAP Analytics Cloud Connections

The following parameters need to be filled in:

Name
Tenant URL
Token URL
Client ID and Secret for the login.

Additionally, the connection mapping to other systems can be read and maintained. This enables the where-used information between the SAC system and systems of other types.

SAP HANA Connections

The following parameters need to be filled in:

Name
Database
Server
SQL Port
SSL if required
Login with User and Password

Additionally, the connection mapping to other systems can be read and maintained. This enables the where-used information between the HANA system and systems of other types.

Expert mode: alternative for complex connection scenarios

In special cases, it is more complex to connect to your HANA databases because of the system architecture on your side (e.g. proxies or special ports).
In this case, you can use the 'Expert mode' and create your own connection string.

Please use the 'Expert mode' in consultation with your HANA IT administrators.
(In the connection string, the user and password information is not needed and will not be saved)

Every parameter you need can be found here.

SAP S/4HANA Connections

The following parameters need to be filled in:

The SID of your SAP BW system
The domain of your Server
Instance number
Client number

Optional parameters are:

Function Module Prefix of the function module RFC_GET_STRING

Since version 2023.2 of Enterprise Glossary, the Function Module is optional for certain versions of SAP BASIS, see here: Function module RFC_GET_STRING

HTTPS-Port is needed for the download of SAP BW Queries
SAP Router String
Logon Group and
Delimiter is needed to get the data from SAP. Per default it is set to ¦. If you use that character in description in SAP, please change it.

Other than that, the connection has to have a Name, and to make the connection User name and Password have to be maintained.

MS Power BI Connections

It is more complex to set up every connection parameters for Power BI. Everything what had to be done is described here.

The following parameters need to be filled in:

Authorization URL per default https://login.microsoftonline.com/<Directory (tenant) ID>/oauth2/v2.0/authorize how to get the Tenant ID here
Scope the default Scope is https://analysis.windows.net/powerbi/api/.default
Client ID
Client Secret

Theobald Xtract Universal.iQ

To connect with a running Theobald Xtract Universal.iQ instance fill in the following parameters:

Properties

Name — a unique display name for this connection within Enterprise Glossary.

Theobald System

Xtract Universal.iQ Endpoint — the base URL of your Xtract Universal.iQ instance, including protocol and port. The Ports needs to be the API Port, defined by Xtract Universal.iQ. Most likely this is port 8075.
Example: http://192.12.XXX.XXX:8075/

Container installations: If Enterprise Glossary is running inside a container, localhost or 127.0.0.1 cannot be used as the endpoint address, even if XIQ runs on the same host machine. Use the host machine's actual IP address instead.

Log In

User name — the username configured in Xtract Universal.iQ for API access.
Password — the corresponding password.
Use Windows Authentication — Activating the toggle switch allows authentication via Active Directory (AD) without storing credentials explicitly if Xtract Universal.iQ and the Enterprise Glossary run on the same Windows host.

Support for Microsoft Entra ID authentication s planned for a future release

Data Preview

The HTTP/HTTPS port is required to navigate to the Xtract Universal.iQ service endpoint. Please set the Port which is used for the UI in Xtract Universal.iQ. Most likely this is port 8077.

Connection Mapping

For each connection listed in the Connection in Enterprise Glossary column, the matching Connection in Xtract Universal.iQ can be entered.