Skip to Content
Technical Articles
Author's profile photo SAICHARAN SRINIVASAN

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

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:

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)

Conclusion:

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

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Rutuja Thakre
      Rutuja Thakre

      Hi Saicharan,

      I have done all the configured you mentioned in your blog.

      Can you share the jdbc url you have configured ,i cans see additional parameter like timeout you have put.

      Also i am facing the below error while while testing the scenario.

      org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host servername, port 1433 has failed. Error: "servername. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall."., cause: com.microsoft.sqlserver.jdbc.SQLServerException: The TCP/IP connection to the host servername, port 1433 has failed. Error: "servername. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.".

      Instance is running on the host and i have did the IP whitelisting as well on the sql server database firewall.

      can you suggest what is the issue.

      Thanks,

      Rutuja

      Author's profile photo Junwoo Park
      Junwoo Park

      I am also facing same error.

      nobody answered from sap.