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=sql-server-ver15)
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=sql-server-ver15) 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)
Its a long awaited feature request to SAP and happy that now we can use SQL/Oracle now.