Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
cancel
Showing results for 
Search instead for 
Did you mean: 
kirankerudi
Active Participant
0 Kudos
With the recent update, the JDBC adapter now enables you to connect to on-premise databases from the Cloud Integration tenant. Let's put this to a test.

The Scenario :

With HTTP GET as a trigger, pass a SELECT Query to the JDBC Server and get the result of the query back as XML.

Tool Used:

SOAP UI

Setup procedure:


1st: Download the Microsoft JDBC Driver for SQL Server from here.

2nd: In the tenant go to Overview->JDBC Material->JDBC Driver and Click on 'Add' to add the downloaded JDBC Driver. Once deployed, it should look something like below.


3rd: Setup Cloud Connector 'Cloud to On Premise' as shown below.


4th: Back in the tenant go to Overview->JDBC Material->JDBC Data Source and Click on 'Add' to add the JDBC Data Source as shown below and deploy.


5th: Create an Integration Flow as below and deploy.


 

That's all with the setup. Now, let's test this using SoapUI.


And that's it! Easy..

!! Since this was just a test on JDBC Connectivity, please excuse the conventions (things are Hardcoded or might not be the best practice). Add comments or suggestions and make this a better blog for future references. 

 

References:

JDBC Receiver Adapter

Cloud Integration – A Simple Demo Scenario Using the JDBC Adapter

Configuring JDBC Adapter: A Step-by-Step Guide

Cloud Integration – Using the JDBC Adapter to Implement a Robust Scenario that Handles an Exception.
Labels in this area