I need to work with SQL Sever Data showing it in some WIX pages.
I have a Rest API that help me to get this data to WIX.
Now I’m importing the data to collections and I use the Collections data in the Pages where I show it.
But I wonder if it could be better to use the SQL Server data “directly”, I mean without using the Collections step. If is it possible how can I do it?
There are several tables so I’ll have to do the process of import data very often and it need to be as fast as possible.
Have a look at Yisrael’s links from a previous post.
For accessing an external database, refer to the following:
Corvid: Working with External Database Collections
Corvid: Adding and Deleting an External Database Collection
External Database Collections API
Github repository for wix/corvid-external-db-mysql-adapter
Thank you! I’ll study this information
@ givemeawhisky : The link Corvid: Working with External Database Collections describes exactly what I need! Thank you very much!
But it has some points that I didn’t understand, mainly in the “Creating the Adapter” information. I tried with the GitHub example but it was too difficult for me. Is there any other tutorial where I could find more simple information to create the adapter? (I already have the Rest API connected to the SQL Server DB)