JDBC Driver for SAP Gateway

Build 24.0.9175

Creating a SAP Gateway Destination

To establish a connection to your SAP Gateway using the SAPBTP AuthScheme, you need to create a SAP BTP Destination and generate a service key for the corresponding service instance.

Create a Destination to your SAP Gateway instance

In this step, you will create a connection between SAP BTP and your SAP Gateway instance.

  1. Login to SAP BTP Cockpit and navigate to the SAP BTP subaccount.
  2. Under Services > Instances and Subscriptions, select the Destination instance where your SAP Gateway Destination is located. If there is no Destination service, you should create a new one via the Create button.
  3. In the left navigation panel click Destinations, under Connectivity and click on Create Destination.
  4. Configure the below Destination properties with your selected authenticaiton method. In this example we are using Basic Authentication.
    • Name: ES5 or if using a shared account, <unique id>_ES5
    • Type: HTTP
    • Description: SAP Gateway ES5
    • URL: Your SAP Gateway service url
    • Proxy Type: Internet
    • Authentication: BasicAuthentication
    • User Name: Your ES5 Gateway user
    • Password: Your ES5 Gateway password
  5. Check the Use default JDK truststore checkbox.
  6. Enter the following Additional Properties depending on your SAP Gateway configuration by clicking the New Property button for every new property.
    • Type: true
    • Type: Gateway
    • Type: odata_abap,dev_abap
    • Type: ABAP
    • Type: 002
    • Type: true
  7. Lastly, click Save and verify the connection by clicking on Check Connection.

You can set the name of the created SAP Gateway Destination to the DestinationName connection property.

Create a Service Key

In this step, you will create a Service Key between SAP BTP and your SAP Gateway instance.

  1. Login to SAP BTP Cockpit and navigate to the SAP BTP subaccount.
  2. Under Services > Instances and Subscriptions, select the Destination instance where your SAP Gateway Destination is located.
  3. On the opened tab for the selected instance, click Service Keys > Create.
  4. Provide a name for your service key and click Create.
  5. Once the Service Key is generated, you will find the following connection property values mapped to the corresponding keys:

These values are necessary for configuring your connection properties to your SAP Gateway instance.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175