Configuring JDBC Adapter: A Step-by-Step Guide
In this blog, we will cover detailed steps to configure a JDBC Receiver Adapter on SAP Cloud Integration 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.
- Provision HANA/ASE database in one of the subaccount.
- Generate an access token for the HANA/ASE database. For more information, see Give Applications in Other Subaccounts Permission to Access a Database.
Configuring SAP BTP Cockpit for Granting Permission to access Database:
- Login to SAP BTP Cockpit application, and navigate to the specific subscriber’s subaccount.
- 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.
- To create databases in your subaccount, refer to Creating Databases.
- 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.
- Use the Database ID and generated Access Token to configure a JDBC Data Source.
Creating JDBC Data Source Aritifact
- Login to SAP Cloud Integration Web application.
- 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.
- 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.
- In the Connection tab, provide the name of the already configured JDBC Data Source in the JDBC Data Source Alias field.
- After configuring the remaining parameters, you can Deploy the integration flow.
Now you will be able to access other databases with JDBC Receiver Adapter!
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
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.
Quick update from the CPI-IS product road map.SAP is busy developing JDBC connectivty to integrate on-premise DB systems and available from Q1 2019.
Thank you for providing this helpful step-by-step guide.
Would you please help to elaborate a bit further for step 4 of Configuring Cloud Platform Cockpit for Granting Permission to access Database procedure?
In this step 4, we need to provide application in the format <account>:<application> to generate the access token that we will use when adding new JDBC Data Source. What application name should we use? The Subaccount (receiving the permission) is the subaccount name for the Cloud Integration tenant, is it correct?
Many thanks in advance for your help!
Sorry, for the delayed reply!
hope this blog will help you:
Thanks Sharath for the reference to Peter's article on demo scenario. This is very helpful!