Skip to Content

CPI Connectivity to Microsft SQL Server using Open Connectors

Hi Experts,

I am working on building an integration from SAP C4C to Microsoft SQL system hosted on Azure platform via CPI.

Since we do not have a JDBC adapter to post data to a database, I tried using Open Connectors as an alternative route. Below is the approach followed.

Step1: A database is already present in MS SQL with a Table created.

Step 2: Build an Iflow from CPI to connect to SQL. For this, I created a trial CPI subaccount for Europe Region to use Open connector for MSSQL & subscribed to the Open Connectors Service. All the necessary details such as Hostname, Port, Database name, Username and password were available for adding in the MSSQL Connectors Authenticate instance section.

Step 3: Launch the Open Connector Service & Create an Instance connection. But I am unable to connect to the SQL system and the error is as below-
"Failed to authenticate with provider during provisioning. Please check your credentials or instance configuration"

The firewall rules have been created within Client Network using the SAP recommended Port, Protocol & IP Ranges.
I have tried to connect using separately the host name as well as the IP but both connection failed with same error. Inside the client network I could reach the concerned Host & IP using ping, telnet & tracert from command prompt.

Please help me with some inputs on how to have a connection eshtablished from CPI to Microsoft Azure MSSQL system.

Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.