SAP Cloud Integration (CPI/HCI) || JDBC Adapter (Part 1) || Everything you need to know, A step-by-step guide || Pre-requisites and Configuration
Hello CPI Enthusiasts,
This series covers all about JDBC Adapter, and here are list of blogs:
Part 1: Pre-requisites and Configuration
Part 2: Update the DB using JDBC adapter via a Stored Procedure
Part 3: Update the DB using JDBC adapter via a Stored Procedure (Parameter as XML Type)
And, this is Part 1:
This blog post will cover everything I have experienced so far, configuring a JDBC adapter. I will mention what requirement I got i.e. the scenario and what I did in order to establish the connectivity.
I have a requirement to connect to an SQL and Oracle Database, poll data from various tables using a Stored Procedure and post it in SAP.
STEP 3: Cloud Integration aka CPI aka HCI || Add JDBC Data Source
Location ID: CPI’s Location ID.
Cloud Connector: Check the checkbox.
STEP 4: Cloud Integration aka CPI aka HCI || Design Integration Flow with JDBC Adapter.
The below is how the iflow will look like for sending poll request, connecting to DB and polling the data to further process the data.In the Content Modifier’s Message Body, write the request for Stored procedure call as the below:
<?xml version="1.0" encoding="UTF-8"?><ROOT> <SELECT> <ROW action="EXECUTE"> <table> <!-- Stored Procedure Name--> StoredProcedureName </table> </ROW> </SELECT> </ROOT>
In the JDBC adapter, just mention the Data Source name which you created in STEP 3.
Hope you had a good read.
If you wish to know more, or have any queries on this blog, then please feel free to drop a comment.
Thanks & Regards,