We have a database hosted on Azure that contains 45k+ rows of unique data. Each row represents a "Company", and contains columns titled "Company Name" "Industry", "Country", "State" and "Sub Region". It also contains a lot of other data, but this is not really relevant for this ask. This is an ever growing database.
Our website is hosted on Hubspot CMS. We now want to create a way for clients / website visitors to search if a specific company is on our database i.e. someone gets to the site, they see some information about our solution and they can input a company name to see if that company is on there, along with the location details and industry details we have stored - this would appear in a simple table. Alternatively, the person could apply specific filters to find out what companies are available within a given country and /or against a specific industry.
We have been looking at solutions in Hubspot CMS that could work for this, but seem to hit a deadend because we cannot use HubDB (this is partially because of the data limits, and partially because we don't want to have 2 versions of the database).
Is anyone familiar with how we could approach this using a 3rd party solution attached to HubSpot CMS? Or have any experience using alternative 3rd party solutions?
At the moment, we are looking at having to do this on Wordpress as an alernative.
Hey @SFoley4, thank you for posting in our Community!
To integrate your SQL database with HubSpot CMS, consider using a third-party solution like a REST API connected to your Azure database.
You could create a lightweight web app or widget to handle search and filter functionality, then embed it into your HubSpot site using iframes or custom modules.
.png "HubSpot Alumni"){kind=icon}
