Reputation: 113
I want to extract data from on-premise SQL Server database using google dataflow job, so wanted to whitelist the dataflow VMs IP. To whitelist IP at on-premise SQL Server need a static IP. Please let me know if more details are required.
Upvotes: 1
Views: 1886
Reputation: 4032
Regarding you question on how to whitelist your VM's IP addresses in you source application/provider, there is an approach that you can use VM as a NAT gateway or directly reserve an external IP address to your VM.
You can use one of the following options:
Create a Google Cloud Engine instance and a static External IP address, link. In this case, you would have to configure all the external IPs manually. The path is: Compute Engine > VM Instances > Networking > Click in the pen under Network interfaces > External IP (drop down) > Create IP.
Using NAT Gateway: according to the documentation, NAT Gateway, in summary, helps users create complex networking scenarios by making changes to the routes collection. This link shows how to configure a NAT Gateway. It allows you to tag multiple VMs without IP addresses to the Gateways instance.
I believe both would suit your case. Please let me know if it helps.
Upvotes: 1