Do external database integrations work with the Wix UI?

Ask the community
,
1

Thank you @anthony for your response. What I’ve figured out so far is that when using external database/ collection with Wix. Regardless of how you create the database (using GCP or self-hosting) the Wix’s GUI based connection doesn’t work. By that I mean creating a dataset and connecting fields from the GUI. Instead, users have to write backend code that can send and receive data from the database.

2

Gotcha. From the documentation it does seem that way but I’ll ask internally as well and let you know if they know of any way to have these integrations work within the UI.

1 Like
3

I checked with the team and it should integrate with Datasets in the UI as well.

Also it looks like for custom adaptors they need to provide the following endpoints: Introduction - Velo SPI Reference - Wix.com perhaps this is the reason it’s not showing up in the UI for the custom self-hosted case?

For the Google Cloud SQL deployment I’m not sure. Best place to report this not providing data in the UI is customer care: Contact Wix

4

Ideally the UI should work but what I practically face and even confirmed from a forum online was that when you use UI you’re not able to send or receive data from the external collection. I personally get the following error in the docker container logs.

UnauthorizedError: You are not authorized
    at RoleAuthorizationService.authorizeRead (/usr/lib/app/main.js:8643:19)
    at /usr/lib/app/main.js:10706:44
    at Generator.next (<anonymous>)
    at fulfilled (/usr/lib/app/node_modules/tslib/tslib.js:166:62) {
  status: 401
}

Online I found a form that mentioned to use the suppressAuth option in the code to get it to work, and that’s how I’m doing it right now.

5

It seems like this might be related to not having the role recognized by the database. I’m not certain what this would look like for a self hosted DB but there’s instructions on how to set this up on managed DBs here: https://dev.wix.com/docs/develop-websites/articles/databases/external-databases/introduction#configure-access-roles-secrets-and-environment-variables

From talking to the team they say that when external DBs are connected they will read/write data in the UI just the same as Wix’s Content Collections so it should work once the setup is correct.

Also if this issue persists on managed DBs that we have prebuilt integrations for then really would be best to reach out to customer care as there may be a bug: Contact Wix

1 Like