Accessing SQL Database outside of wix?

Ask the community
,
1

I am working on a mobile application that links with a website and I am wondering if I can access my SQL database hosted my Azure through Wix for reading and writing data.

Or even access Wix database from my applications using connection strings?

2

If your SQL database has a REST interface, then you can query it using fetch() .

You can expose an API of your site’s functionality using the wix-http-functions API. So, you can allow access to your Wix database by building your own API.

I hope this helps,

Yisrael

3

Hi Yisreal,

Thanks for the reply!

Using the fetch() will allow me to access my existing sql database costed by Microsoft Azure?

Scott

4

If the host has a REST interface.

5

Okay, I will look into and hopefully this helps. Really want to use wix as the main platform to host.

6

Why not just move your database over to Wix as well. Would make things much easier, more reliable, and more responsive. Plus it’ll be a whole lot easier to maintain.

7

I wouldn’t mind using the wix database but I need to access the the database via mobile app and desktop software.

I called Wix and they said achieving this is not possible as the wix database is bound to the website only?

8

Hi,

out of the box direct access is not possible, but you could build REST API on top of Wix, that would allow your Mobile App and Desktop App to communicate with Wix Site.

Check out HTTP Functions:

But as Yisrael said, you could just as well build API on Azure and access it from all three consumers. The choice is in your hands.

9

Hi Giedrius,

Thanks for the reply, I think the API on Azure is the best way to go as all my data is there.

I will have to do a bit more digging into as it is something new I am taking on.

  • Scott
10

Let us know if you need any help with Wix Code.

Good luck!

11

I will give it ago and if I need help I will comment back!

12

The link sounds like what I’m looking for at a glance. I’m working on an on site (not azure) analysis services database and would like to aggregate the users that sign up on my site into the analysis services database for update triggers that feed back processed information into my embedded power bi reports in my wix site. I could probably use some help with this. I am not building a moble app for this yet.