So, here are the steps:
STEP 1: Cloud Connector || Cloud to On Premise, Mapping Virtual to Internal System:
To complete this step, you will need Internal Host and Internal Port of the database.
So, in Cloud Connector, in the Cloud to On Premise, Add System Mapping.
Back-end Type: Non-SAP System
Protocol: TCP
Internal Host: The IP Address received for SQL/ Oracle Database.
Internal Port: 1433 (For SQL) / 1741 (For Oracle)
Virtual Host: Could be same same as Internal Host, but advisable that you keep a different one.
Virtual Port:Could be same same as Internal Port, but advisable that you keep a different one.
STEP 2: Cloud Integration aka CPI aka HCI || Add JDBC Drivers
Download the drivers of Oracle and SQL from their official website, for example the below one for Oracle. Always download the latest version.
After you have downloaded, add it in the JDBC Material > JDBC Driver
Pretty easy, right?
Name: Name of the Data Source, as per your naming convention
Description: A brief description
Database Type: Microsoft SQL Server/ Oracle/ ...
User ID: User ID to access the database.
Password: Password to the User ID mentioned.
JDBC URL: The below is how you would form the JDBC URL:
SQL:- jdbc:sqlserver://virtualHost:virtualPort;DatabaseName=databaseName;
Oracle:- jdbc:Oracle:thin:@virtualHost:virtualPort:databaseName
Location ID: CPI's Location ID.
Cloud Connector: Check the checkbox.
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.
That's it.
Deploy the IFlow.
And, it's a wrap! 🎆
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
22 | |
8 | |
6 | |
5 | |
5 | |
5 | |
4 | |
4 | |
3 | |
3 |