How to consume MS-SQL on Azure using SAP CPI (JDBC configuration)?

[saicharansrinivasan]

In this Blog post we will discuss, How to consume MS-SQL on Azure using SAP CPI (JDBC configuration)?

Pre-requisite from Azure team/colleague:

• Azure Table must be created


• Azure JDBC Connection String/JDBC URL


• Azure JDBC connector .Jar file (This can be downloaded directly from the https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view...)

Actions from SAP CPI end

Step1: Login to tenant itspaces and choose JDBC driver tab like shown in the below picture and click on “add”

 

Step2: Choose the JDBC type and click on browse and select the Jar file downloaded from (https://docs.microsoft.com/en-us/sql/connect/jdbc/download-microsoft-jdbc-driver-for-sql-server?view...) and click on deploy (in my case I used JRE8)

Step4: Now navigate to the JDBC data source tab and create the data source for MS SQL server, it will appear as shown below

Step5: Once after filling the details, deploy the data source, in my case it looks like the below picture after deployment

 

Step6: Now the JDBC is ready to consume! I Designed a Simple iflow for checking the working of SQL here:

 

 

Testing result of the above flow:

(In the test I inserted a row into the DB table)

Conclusion:

Its a long awaited feature request to SAP and happy that now we can use SQL/Oracle now.