How to Connect to Azure SQL Database from SAP Data Services

Question

Hello,

I need to get data from Azure SQL Database on On-Premise SAP DataServices.  But, I' m getting an error because Azure enforce encryption (SSL/TLS) for Data Services connection. Data Services need to connect Azure SQL with certificate. 

How can I export the certificate from Single Azure SQL Database?

Best Regards.

Answer 1

Just to reitorate your use case, you have an Azure SQL Database (Single Instance) where you need to export the data from, and import it to an on-premise instance of SAP dataServices. 

Is this for SAP HANA? As we do have a connector for Azure Data Factory, in the case that SAP DataServices will not be supported here. More info: Pipelines and activities in Azure Data Factory

Can you detail the available connection strings the SAP DataServices is looking to use to connect? There is one thing you can try, and that is to pass the following:

set the hostNameInCertificate property to *.domainName. 

More Information: Using Encryption Requires Setting hostNameInCertificate

Please let me know if this helps, as Azure SQL database should not require a client certificate to connect.

Thanks,

Mike