How to connect Azure database to Wix

Andrew Haning 5

Hi, I'm doing a project connecting the Azure database to the Wix platform. I followed the instructions from the Wix website, but there were missing details, so I struggled to test the API phase. The suggested testing API is deployed by using Curl. From the Wix side, the connection to the external database just requires the link to the web app and the password(secretKey). I gave it a shot at that, but Wix couldn't connect to the web app. I assume if the API works, Wix can connect to API - Web App. Is this correct? If I upload data to the Azure web app and it shows up the data, then the Wix connects to the API, or does it require other validation methods of connection such as network policies?

Thank you,

brtrach-MSFT 15,356 Reputation points Microsoft Employee

2024-02-15T02:59:01.65+00:00

To clarify, you are trying to connect to the Azure Database for MySQL from Wix using an API, is that correct? If so, have you already created the API and deployed it to Azure App Service? If you have already deployed the API to Azure App Service, you can test it using tools like Postman or cURL. Once you have confirmed that the API is working correctly, you can then use the link to the API in Wix to connect to the Azure Database for MySQL. Regarding your question about validation methods for the connection, it is recommended to use network security groups to restrict access to your Azure Database for MySQL. You can also use SSL/TLS encryption to secure the connection between your API and the database. Let me know if you have any further questions or if there is anything else I can help you with.
brtrach-MSFT 15,356 Reputation points Microsoft Employee

2024-02-16T00:10:19+00:00

@Andrew Haning Let us know if you've had a chance to review my comment or Thiago's answer. We look forward to assisting you further.
Andrew Haning 5 Reputation points

2024-02-20T03:25:07.1266667+00:00

@brtrach-MSFT Thank you for your advice and support. Yes, I'm trying to connect to the Azure SQL Database to Wix using an API. I've already created the API and deployed it to Azure App Service, but there's no data there. I'll configure my API and let you know if I have further queries.

1 answer

Thiago Cardoso 0 Reputation points Microsoft Employee

2024-02-15T03:05:04.15+00:00

you should integrate app services with vnet integration , and then integrate with WIX.

also I recommend to test vis curl.
https://dev.wix.com/docs/develop-websites/articles/databases/external-databases/microsoft/integrate-your-microsoft-azure-database-with-your-wix-site

in my experience most of the issues is related to secretkey.
Please sign in to rate this answer.
Andrew Haning 5 Reputation points

2024-02-20T03:12:05.14+00:00

Thanks Thiago for your suggestions. I'll start by integrating vnet to Wix.
Sign in to comment

Share via

How to connect Azure database to Wix

1 answer