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!