Technical Articles
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:
- 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)
Conclusion:
Its a long awaited feature request to SAP and happy that now we can use SQL/Oracle now.
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
I am also facing same error.
nobody answered from sap.