Managing Tenant Connections

Objective

After completing this lesson, you will be able to manage your tenant connections.

The Manage Tenant Connections Feature

In this section, we dive deeper into the Manage Tenant Connections feature, which is used to create and configure tenant-specific connections within the Universal Model. This functionality allows for flexible and environment-specific data routing, ensuring that development, testing, and production environments can have separate configurations yet remain consistent in their naming and structure.

The SAP Manage Tenant Connections screen showing one tenant connection in the list.

Purpose of Manage Tenant Connections

The Manage Tenant Connections application is integral for establishing connections that are tailored to specific tenants. This feature ensures that connections can be environment-specific, such as development (Dev), quality assurance (QA), and production (Prod), while maintaining uniform connection names across these environments.

Steps to Set Up Tenant-Specific Connections

Step 1: Create a Connection in Development Environment​

Initial Setup in Development:​

Navigate to the Manage Tenant Connections application.​

Create a new connection, giving it a meaningful name, such as demoIbhc.​

Specify the connection type, for instance, a HANA connection.​

Point this connection to the appropriate schema used in the development environment, such as UN_demo_schema_dev.​

Step 2: Replicate Connection in QA Environment​

Set Up Connection in QA:​

Switch to the QA environment within the Universal Model.​

Access the Manage Tenant Connections application within QA.​

Create the same connection using the exact name as in development (demoIbhc).​

However, point this QA connection to the QA-specific schema, such as UN_demo_schema_qa.​

Step 3: Configure Universal Model to Use Tenant-Specific Connections​

Configuring Readers and Writers:

Within your Universal Model configurations, when setting up readers and writers, you can specify whether to use tenant-specific connections.​

Look for a checkbox labeled Use Tenant Connection.​

By selecting this checkbox, the system refers to the tenant-specific connections defined in Manage Tenant Connections rather than the global connection settings.​

Create a Tenant-Specific Connection

Steps to Create a Tenant-Specific Connection

The SAP interface for creating a new tenant connection, showing the creation dialog and the general information form.

Step 1: Specify the Connection​

Accessing Manage Tenant Connections:​

Navigate to the Manage Tenant Connections application within your Universal Model.​

Initiate the process to create a new tenant-specific connection.​

Select an Existing Connection:

A pop-up appears, displaying a list of connections that have already been defined in the global Manage Connections settings.​

Select the connection that you intend to override for the tenant-specific configuration.​

Step 2: Choose the Schema

Schema Selection:

Once you select the connection, another pop-up displays all the schemas available to the current user ID.​

This screen lists every schema that the ID has access to.​

Override with a Tenant-Specific Schema:​

Choose a different schema from the list to be used for the tenant-specific connection instead of the default schema.​

For example, if the default connection points to UM_demo_schema, you can select QA_demo_schema for the QA tenant.​

Typical Three-Tier Landscape Setup

In an SAP landscape, it's common to have a three-tier structure consisting of a Development (Dev) tenant, a Testing (Test or QA) tenant, and a Production (Prod) tenant. Each of these environments can require different schemas even if they share the same connection names. Tenant-specific connections allow you to adapt to this landscape by pointing a single connection to different schemas in each environment.

A diagram showing how DEV, TEST, and PROD environments connect to their respective database schemas: DEVSCHEMA, TESTSCHEMA, and PRODSCHEMA.

Typical Three-Tier Landscape Setup

Three Tiers:

  • Development Tenant (Dev)
  • Testing Tenant (Test or QA)
  • Production Tenant (Prod)

Objective: To configure tenant-specific connections that adjust according to the schema requirements of each environment.​

Scenario: Using Tenant-Specific Connections​

Problem: You have a connection (let's call it connection1) used across Dev, Test, and Prod environments. The schema name differs in each tenant:​

  • Dev Schema: dev_schema
  • Test Schema: test_schema
  • Prod Schema: prod_schema

Solution: By using tenant-specific connections, you can configure connection1 to point to the correct schema in each environment.