I have a giant and fairly complex SQL Relational Database that is not easy to transfer to the Wix Database. I searched and read all the suggested links however still, I couldn’t find an updated solid source about how I can connect my on-premise database to the WIX web page. So, I am looking after a step by step or detailed guidance on how to create a Rest API or, an Adapter to connect the web page to the Ms.SQL Server 2014+ database. Please advise?
1 Like
See the article Corvid: Working with External Database Collections and the External Database Collections API .
Thank you @ Yisrael (Wix) but not very helpful to me !
No one else at WIX (Corvid team) ) has any idea !!!
Again I need help on how I can DIRECTLY connect the Wix web site to the SQL server with no intermediate tool including the Rest API?
My Database has to be relational because there are many scheduled queries to run on the database some of them 4 times on every single day. So, it’s very complicated to implement those on Corvid Nosql DB, or my knowledge is not enough around that. Also, I have not found any nice and neat reference to see the possibility of converting SQL Server DB/Jobs/Sproc/Functions/Security to Corvid. Hence, I prefer to remain on SQL Server 2016 which can understand TSQL/MDX/DAX/JSON queries as well but Corvid is still a rudimentary DB !
Also, I can not create Rest API for three reasons:
1- Lots of Performance disadvantages (Especially for a big size database that is appx 670Gb)!
2- Redesigning is so complex in NoSQL because of the complexity. (it is a huge project !)
3- creating a rest API for many many queries from the App to the Database
4- There are interactive SSRS reports which I don’t know how to create in Corvid! Although how to embed them is another topic too!
Wix Data is not Nosql. It is a database created at Wix and based on MongoDB to the best of my knowledge. It is intended to be accessible and scalable.
If you really need Ms.SQL server then you can follow the links I posted, or check the Wix Marketplace - it’s a place where you can look for Corvid experts for hire.
Sorry Sir, MongoDB is a NOSQL Json document base database management system so, Corvid also count as a NoSQL.
However, based on my previous reasons on my above post I can’t move to Corvid and I have to remain on Ms.SQL Server and I need a help for connecting directly to Ms.SQL using a SQL Native Client or an Ado.Net connection tool.
Yes, it is NoSQL - I was thinking of something else. MongoDB is especially suited to the Wix infrastructure where it has been adapted and crafted by Wix to provide ease of use and scalability.
If you really need Ms.SQL server then you can follow the links I posted, or check the Wix Marketplace - it’s a place where you can look for Corvid experts for hire.
You may wish to consider other hosting or server options.
Mike,
I have noticed he same thing. I also need to connect a mySql database to my wix site. I have viewed the links that have been provided and no matter how many times they are listed to look at, I haven’t been able to figure it out. I pay for wix to host my site and think there should be a little more help forthcoming than just listing the same old links. Even if it’s my problem that I don’t understand, being a paying customer, I feel there could be more help provided. Anybody have an actual example on how they connected an external database to there wix site?
1 Like
Hello, I have a Relational Database on SQL Server Management Studio which I synced to Visual Studio. Is there anyway I can connect this DB to my Wix website?
You can use npm @frangiskos/mssql for MSSQL connection on backend.
Not addressing the concerns of SQL Database Admin/Developers !
Please first read the comment on: " Jun 25, 2020 "
@yisrael-wix , Corvid should not resist on their DB platform which is so naïve and incomplete!
Also, Rest API is not a good option for the large scale projects /DBs! Corvid should provide a SQL environment or let us connect our in-house DB directly via an OLEDB Adapter ! I encourage you to re read my above comment on " Jun 25, 2020 " .
1 Like
Refine the queries, fetch only the results, create the reports using TSQL/SP. Yes you will need to open the db access for the internet (with security layer). Using the npm module is more easy than create a middle adapter between wix - mssql. Npm module is only a redirector to log in, to send queries and to get results.
Other option is to create a REST API on mssql (get/post) side with SSRS. Returning JSON.
On wix side using fetch or XHR.
Just ideas, Good luck.