topic Integrate HubSpot to Mysql Server via static IP address in APIs & Integrations

Integrate HubSpot to Mysql Server via static IP address

Ignazio — Mon, 29 Aug 2022 09:54:03 GMT

Hi there!

I need to integrate HubSpot to Mysql Server via static IP address (for security reasons).

Is it possible to limit a single static IP address for all serverless functions for an HubSpot instance?

This practis is also recomended by AWS: https://docs.aws.amazon.com/prescriptive-guidance/latest/patterns/generate-a-static-outbound-ip-address-using-a-lambda-function-amazon-vpc-and-a-serverless-architecture.html

Re: Integrate HubSpot to Mysql Server via static IP address

Teun — Mon, 29 Aug 2022 13:14:31 GMT

Hi @Ignazio ,

A static IP for serverless functions or webhooks is currently not possible. But @JBeatty suggested a nice solution in this post.

Re: Integrate HubSpot to Mysql Server via static IP address

Ignazio — Tue, 30 Aug 2022 13:56:04 GMT

Hi @Teun and thank you for your reply!

Unfortunately, @JBeatty's solution doesn’t work in my scenario.

My problem is that the serverless function has to open a connection to an external DB, the function does not call an API.

I hope that someone here can find a solution to this situation as well.

Re: Integrate HubSpot to Mysql Server via static IP address

RKon — Sat, 21 Dec 2024 22:03:33 GMT

Hi,

You can try using some 3rd-party tools like Skyvia, Workato, or Zapier. These platforms provide a secure connection between HubSpot, MySQL, and other tools. My personal choice is Skyvia, as it has an intuitive interface and a freemium version to start with. As for MySQL connection, Skyvia also has an agent app to connect to its on-premise version. You can read more about this integration here.

Hope it will be useful.