Skip to Content

In this blog, we will cover detailed steps to configure a JDBC Receiver Adapter on SAP Cloud Platform Integration (CPI) Web application (Neo Environment).

A question may come to one’s mind on “Why do we need JDBC Adapter?”

Consider you have a requirement to connect with HANA or ASE database hosted one of the subaccounts belonging to a customers’ (subscriber) global account. In such scenarios, the JDBC Receiver adapter gives you great flexibility to access and perform operations (read, write, update, or delete) on databases hosted on subscribers global account. The following section describes the prerequisites and the procedure to configure the JDBC Receiver adapter in an integration flow.

Prerequisites

Procedure

Configuring Cloud Platform Cockpit for Granting Permission to access Database:

  1. Login to SAP Cloud Platform Cockpit application, and navigate to the specific subscriber’s subaccount.
  2. If database is not configured for the selected subaccount, then choose Services and search for Data Management for creating and consuming either SAP HANA or SAP ASE database.
  3. To create databases in your subaccount, refer to Creating Databases.
  4. Now generate an Access Token to grant permission to other subaccounts to access a database, we recommend you to read Give Applications in Other Subaccounts Permission to Access a Database.
  5. Use the Database ID and generated Access Token to configure a JDBC Data Source.

Creating JDBC Data Source Aritifact

  1. Login to SAP Cloud Platform Integration Web application.
  2. Select Operation View, and then choose the JDBC Data Sources tile to create a JDBC Data Source artifact to manage a cluster of artifact connections to interact with databases. For more information, see Managing JDBC Data Sources.
  3. Deploy the artifact.

Configuring and Deploying JDBC Receiver Adapter

Consider you have created an integration flow and configured the receiver channel with the JDBC adapter. For more information on configuring the adapter, see JDBC Receiver Adapter.

  1. In the Connection tab, provide the name of the already configured JDBC Data Source in the JDBC Data Source Alias field.
  2. After configuring the remaining parameters, you can Deploy the integration flow.

 

Now you will be able to access other databases with JDBC Receiver Adapter!

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. Pavan kumar

    Hi Sharath,

    Thanks for the info on receiver JDBC adapter in CPI-IS,however a bit disappointed due to limiting its capabilities to SAP Hana or ASE DB’. I presume receiver JDBC adapter functionalities should extend for integrating on-premise SQL/Oracle and other databases.

    Still there is no straight forward solution to integrate on-premise database using CPI-IS(exposing tables to API is not always the solution, For instance sensitive payroll data etc..) other than CPI-DS(for complex data flows, I think this may not be a solution)

    SAP Cloud Platform -Open Connectors does have MS SQL Connectors however still I am not clear on how integration works. Can you please advise how to create IFLOW in CPI-IS integrating on-premise SQL DB?

    Awaiting your feedback

    Cheers

    Pavan Nukala

     

    (0) 
    1. Naresh Dasika

      Completely agree with Pavan. I believe this is the first step towards integrating with databases.

      Going forward SAP should enhance or bring additional connectors to integrate with on-premise databases.

      (0) 

Leave a Reply