I have a client I’m working with that has an existing “homemade” web application with SQL database. I’m building a Bubble app for them and we are hoping we can tie the two together.
I’ve never done anything like that before. Is it possible to connect to ANY SQL database, or only in certain circumstances? What information do I need to request from them to make this happen?
There is a SQL Database Connector plugin that you can install in the Plugins interface within Bubble. In order to access the database, it will have to be available to “the cloud” because the request will come from the Bubble AWS environment. That means they will have to deal with any firewall settings and database remote access settings.
It can be hosted anyplace that allows access from somewhere else. If it is hosted in the cloud already (AWS, Azure, etc.) it is will probably be easy for you to connect to it from Bubble. If it is on your client’s corporate network behind a firewall, it will take some working with their IT department to make it work.
You said your client has a web app with a SQL database. Where is that hosted?