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 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!

from SAP Blogs https://ift.tt/2Dd8LCY



from WordPress https://ift.tt/2SxOr3t


Comments

Post a Comment

Popular posts from this blog

Add Custom Field in Output of Standard Report of ME2N

Image
Author: Vedarth Desai  A very common requirement from customer is to modify the outputs of standard reports. Here I have tried to explain how to modify the standard report  ME2N  output. Requirement Purchase Documents per Document Number: T-code:  ME2N  is a standard report that retrieves a purchase order details via a document number and other user-defined parameters. Minimum parameters in selection-screen we need to pass are valid  Scope of list  and Either of remaining fields. Scope of List defines the format in which report will get display. In general, Report output looks like below.   Here in this output we need to add one additional column which will display some information as per the requirement.  Here let’s add an extra field/column and display ‘Net Order Value Incl. Tax’.      There are mainly 2 steps to do the modification. Add desired field in Output structure. Write code to populate the value in th...
Read more

UK to Receive Egyptian LNG Cargo

British gas terminal Dragon LNG will receive a liquefied natural gas (LNG) shipment from Egypt at the end of October, LNG World News reported. The cargo is being shipped in the Shell-chartered Maran Gas Spetses which will arrive at Dragon LNG’s Milford Haven terminal on October 31. The gas was shipped from Egypt’s Idku liquefaction plant and was sailing in the Mediterranean Sea on October 24. Shell had increased the amount of natural gas exported from its Idku liquefaction plant to 250 million standard cubic feet per day (mmscf/d), up from 150 mmscf/d in fiscal year (FY) 2016/17, an industry source told Al Borsa in September. The Dutch oil giant’s ownership of the Idku plant has enabled it to export natural gas from its offshore Burullus and Rosetta fields. Shell aims to export a LNG argo every 15 days based on the facility’s current liquefaction capacity, the source added. from News – Egypt Oil & Gas https://ift.tt/2ORNMvH
Read more

HANA Housekeeping using HANACleaner

Image
Purpose The blog provide guidelines on the necessary steps that needs to be followed to automate housekeeping task using SAP HANACleaner script. Background It’s really a good practice to set up housekeeping task from the early stage of your project as there are some task which you know in advance whereas some housekeeping task comes after your production system go-live like Table Growth. This blog demonstrate the steps involved to perform housekeeping for cleanup of backup catalog entries. The idea behind performing this activity is that, with time entries in backup catalog table grows which result in higher data footprint at persistent level results in more memory utilization. So, this is one of many tables on which we can perform housekeeping task and keep it under threshold. Overview This section will provide an overview on what is HANA Catalog and where it used and how to check its size etc. and all the relevant information with respect to backup. Backup Files – Delet...
Read more